Setting | Valid Input Formats | Output Format |
|---|---|---|
US (default) | mm/dd/yy mm-dd-yy mmddyy mm/dd/yyyy mm-dd-yyyy mmddyyyy dd-mmm-yyyy dd mmm yyyy yyyy-mm-dd yyyy.mm.dd yyyy_mm_dd mm-dd mm/dd am and pm format in timestamp. Only hours between 1 and 12 are valid. am and pm must be in lowercase. | dd-mmm-yyyy |
MULTINATIONAL | yyyy-mm-dd mm-dd-yy mmddyy mmddyyyy dd/mm/yy dd/mm/yyyy dd mmm yyyy All US formats except mm/dd/yyyy and mm/dd/yy | dd/mm/yy |
MULTINATIONAL4 | yyyy-mm-dd dd/mm/yy dd/mm/yyyy dd mmm yyyy mm-dd-yy mmddyy mmddyyyy All US formats except mm/dd/yyyy and mm/dd/yy | dd/mm/yyyy |
ISO | yyyy-mm-dd yyyymmdd yymmdd ymmdd mmdd mdd dd mmm yyyy All US input formats except mmddyy | yymmdd |
ISO4 | yyyy-mm-dd yyyymmdd yymmdd ymmdd mmdd mdd dd mmm yyyy All US input formats except mmddyy | yyyymmdd |
ISO4T | All ISO4 input formats. If the prefix "T" is used then the absolute time component can use the input format hhmmss as well as the standard hh:mm:ss. For example: Acceptable: yyyymmddThhmmss, yyyymmddThh:mm:ss, and yyyymmdd hh:mm:ss Not acceptable: yyyymmdd hhmmss Acceptable: 'Thhmmss', 'Thh:mm:ss' and 'hh:mm:ss' Not acceptable: 'hhmmss' This is the only case where an absolute time can be entered in format hhmmss instead of hh:mm:ss. To avoid ambiguity, a time field entered in hhmmss format must be 6 characters long. | yyyymmdd ISO4 output format, unless the date includes a time, in which case the format is: yyyymmddThhmmss |
ISO4TC | See description under ISO4T. | ISO4 output format, unless the date includes a time, in which case the format is: yyyymmddThh:mm:ss |
ISO8601 | All ISO input formats | yyyy-dd-mmThh:mm:ssZ where hh is in 24-hour format and Z indicates Zulu (UTC) timezone |
SWEDEN or FINLAND | yyyy-mm-dd yy-mm-dd mmddyy dd mmm yyyy All US input formats except mm-dd-yyyy | yyyy-mm-dd |
GERMAN | yyyy-mm-dd dd.mm.yyyy ddmmyy dmmyy dmmyyyy ddmmyyyy dd mmm yyyy mm-dd-yy All US input formats except yyyy.mm.dd and mmddyy | dd.mm.yyyy |
YMD | mm/dd mm-dd mmdd yymdd yymmdd yy-mm-dd yyyymdd yyyy-mmm-dd yyyy/mm/dd yyyy.mm.dd yyyy-mm-dd yyyy_mm_dd yyyymmdd yyyy mmm dd | yyyy-mmm-dd |
DMY | yyyy-mm-dd yyyy_mm_dd dd/mm dd-mm ddmm ddmyy dd-mm-yy ddmmyy ddmyyyy ddmmyyyy dd/mm/yyyy dd-mm-yyyy dd.mm.yyyy dd-mmm-yyyy dd mmm yyyy | dd-mmm-yyyy |
MDY | yyyy-mm-dd yyyy_mm_dd mm/dd mm-dd mmdd mmddyy mddyy mddyyyy mm-dd-yy mm-dd-yyyy mm/dd/yyyy mm.dd.yyyy mmddyyyy mmm-dd-yyyy | mmm-dd-yyyy |