Hello, I’m trying to import records to a table with a .csv UTF-8 but the dates are not working fine, on my file had
dd-mm-yyyy
On the tool show this:
When the day is less than or equal to 12, it swaps the day and month, but if the day is greater than 12, it keeps it correct. When processed, dates like March 1, or March 12 end up being converted into January 3 and December 3.
How should dates be written to prevent this from happening?
Best answer by Troy Tessalone
ISO (International Organization for Standardization) date and datetime formats are standardized representations commonly used in APIs, databases, and programming.
ISO Formats for date and datetime:
YYYY-MM-DDYYYY-MM-DDTHH:MM:SSZYYYY-MM-DDTHH:MM:SS±HH:MMYYYY-MM-DDTHH:MM:SS.sssZ
+14Hi
Before importing the CSV you may need to first convert the DateTime format in the CSV to be YYYY-MM-DD.
it works with YYYY-MM-DD but with a day before the date, now for the 2025-03-01 save as 2025-02-28 and so on.
+14
That may be related to the Time Zone settings on the field.
+14
ISO (International Organization for Standardization) date and datetime formats are standardized representations commonly used in APIs, databases, and programming.
ISO Formats for date and datetime:
YYYY-MM-DDYYYY-MM-DDTHH:MM:SSZYYYY-MM-DDTHH:MM:SS±HH:MMYYYY-MM-DDTHH:MM:SS.sssZ
Thanks a lot, works with:
2025-03-01-06:00
YYYY-MM-DD-06:00
+6That’s awesome
If you have any other questions, please don’t hesitate to reach out to the Community. We’re always happy to help! 🤗
Enter your E-mail address. We'll send you an e-mail with instructions to reset your password.
