Sidebar
en:transformation:mappings:funktionen:datum:formatdatetime
Table of Contents
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.
Syntax:
FormatDateTime('Date time value','Format')
Examples:
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!
en/transformation/mappings/funktionen/datum/formatdatetime.txt · Last modified: 2024/02/20 08:15 by 127.0.0.1