When you import files that include dates, use the same date format in both the file and the time specification in the ImportDefinition field.
For example, a file that uses the English (United Kingdom) format must use 22/01/2024 for the date January 22, 2024 and not 01/22/2024. See Supported Date and Time Formats for a list of supported date formats when uploading a date value into a date-type field in a subscriber attribute or data extension. The import references the rules in this list to validate the dates in the file.
This table lists the supported date format patterns.
| Pattern | Example |
|---|---|
| <date> <time> | 2024-01-28 16:30 |
| <longdate> <time> | 28 Jan. 2024 16:30:05 |