If you are importing data into a date property and the values do not appear correctly or fail to import, the most common cause is an unsupported date format.
This article explains which date format is accepted and how to fix import issues related to dates.
Accepted date format
Date properties only accept values in the following format:
Month / Day / Year (MM/DD/YYYY)
Examples of valid formats
1/5/2024
01/05/2024
12/31/2023
Both single digit and double digit months and days are supported, as long as the order is correct.
Unsupported date formats
The following formats are *not supported and may cause the import to fail or result in incorrect dates:
31/01/2024 (Day/Month/Year)
2024-01-31 (Year-Month-Day)
31-01-2024
2024/01/31
5 Jan 2024
If your file uses any of these formats, the system will not be able to reliably interpret the date.
Common symptoms
You may be affected by this issue if:
Date fields appear empty after import
Dates are shifted or incorrect
The import completes but date based filters do not work as expected
You receive an import validation error related to date fields
How to fix the issue
Before importing your file, make sure all date values are converted to the supported format.
If you are using Excel or Google Sheets
Select the column containing dates.
Change the column format to a custom date format.
Set the format to MM/DD/YYYY.
Confirm that all values follow the Month/Day/Year order.
Export or save the file and re import it.
Important notes
The import process does not automatically detect regional date formats.
Dates must always start with the month, followed by day, then year.
Time values are ignored for date properties and may cause unexpected results.