The following table contains a list of all date and time formats that are acceptable in the Data Load Wizard. Please consult your integration consultant for a list of date formats acceptable for the data feed.
When using time, a 24-hour clock should be used to distinguish between morning and evening hours. For example, 2:00 PM should be provided as 14:00.
Two-digit year formats are not supported by the Data Load Wizard. Year values must be four digits.
Note: The maximum date supported for custom date fields is November 2077.
| U.S. Date and Time Formats | European Date and Time Formats |
|---|---|
| MM/dd/yyyy | dd/MM/yyyy |
| M/d/yyyy | d/M/yyyy |
| MM-dd-yyyy | dd-MM-yyyy |
| M-d-yyyy | d-M-yyyy |
| yyyy-MM-dd | yyyy-dd-MM |
| yyyy-M-d | yyyy-d-M |
| yyyy/MM/dd | yyyy/dd/MM |
| yyyy/M/d | yyyy/d/M |
| MM/dd/yyyy HH:mm | dd/MM/yyyy HH:mm |
| M/d/yyyy HH:mm | d/M/yyyy HH:mm |
| MM-dd-yyyy HH:mm | dd-MM-yyyy HH:mm |
| M-d-yyyy HH:mm | d-M-yyyy HH:mm |
| yyyy-MM-dd HH:mm | yyyy-dd-MM HH:mm |
| yyyy-M-d HH:mm | yyyy-d-M HH:mm |
| yyyy/MM/dd HH:mm | yyyy/dd/MM HH:mm |
| yyyy/M/d HH:mm | yyyy/d/M HH:mm |
| MM/dd/yyyy H:mm | dd/MM/yyyy H:mm |
| M/d/yyyy H:mm | d/M/yyyy H:mm |
| MM-dd-yyyy H:mm | dd-MM-yyyy H:mm |
| M-d-yyyy H:mm | d-M-yyyy H:mm |
| yyyy-MM-dd H:mm | yyyy-dd-MM H:mm |
| yyyy-M-d H:mm | yyyy-d-M H:mm |
| yyyy/MM/dd H:mm | yyyy/dd/MM H:mm |
| yyyy/M/d H:mm | yyyy/d/M H:mm |