FormatDateTime

The function formats a date value in an EDIFACT compatible date format, a character string (string) is returned. Possible values ​​are:

• 101: for the EDIFACT format yyMMdd
• 102: for the EDIFACT format yyyyMMdd
• 203: for the EDIFACT format yyyyMMddHHmm
• 204: for the EDIFACT format yyyyMMddHHmmss

Alternatively, the formatting can also be specified as a string, e.g. 'DD / MM / YYYY'.

To convert a string to a date, YOU use ConvertDateTimeFromString.

FormatDateTime('Date time value','Format')

FormatDateTime('2007-08-01', '102')

returns '20070801'

FormatDateTime('2007-08-01', '203')

returns '200708010000'

FormatDateTime('2007-08-01', 'dd MMMM yyyy')

returns '01 August 2007', Attention this output depends on the language setting of the server!