Was this helpful?
II_DATE_FORMAT
II_DATE_FORMAT defines the format for date values. It is defined installation-wide. If set, it replaces the default format (the US setting) with an alternative format.
The following are valid II_DATE_FORMAT settings and their output formats:
Setting
Output Format
US (default)
dd-mm-yyyy
MULTINATIONAL
dd/mm/yy
MULTINATIONAL4
dd/mm/yyyy
ISO
yymmdd
ISO4
yyyymmdd
ISO4T
yyyymmdd unless the date includes a time, in which case the format is: yyyymmddThhmmss
ISO4TC
yyyymmdd unless the date includes a time, in which case the format is: yyyymmddThh:mm:ss
SWEDEN or FINLAND
yyyy-mm-dd
GERMAN
dd.mm.yy
YMD
yyyy-mmm-dd
DMY
dd-mmm-yyyy
MDY
mmm-dd-yyyy
For example, if the II_DATE_FORMAT setting is ISO, the dates are output as yymmdd. If you enter a date using a similar, six-character format, such as mmddyy, the date is interpreted on output as yymmdd. For example, if you enter the date March 9, 1912, as 030912 (mmddyy) and II_DATE_FORMAT is set to ISO, this date is interpreted as Sept. 12, 1903 (030912 as yymmdd). If the date you entered cannot be interpreted as a valid date in the output format, you receive an error message.
Note:  When using the _date4() function (MULTINATIONAL4), the output format for the year value always returns ‘yyyy’.
Last modified date: 01/30/2023