I have 2 columns in a table which are date based. The due date column always seems to format correctly, however the testdate column randomly changes some of the dates to US format (mm/dd/yyyy) when it should be dd/mm/yyyy. It doesnt happen for new entries, only ones I have previously imported in.
If I change it to a text column the formatting is correct, however I then loose the ability to do other things with the dates later on.
Can someone point me in the right direction here?
How were the original entries imported, and in what format?
The problem is, if you import dates that use either dd/mm/yyyy or mm/dd/yyyy format, some of those date can be ambiguous. For example, let’s consider todays date - September 12. You might write that as 12/09/2025, but it can also be written as 09/12/2025, and both are correct - depending where you live. When you import a date like that into Glide it doesn’t know which format you are intending, and so it always defaults to US format (mm/dd/yyyy).
The way to avoid this is to always ensure your dates are formatted using the ISO-8601 standard when importing, that is YYYY-MM-DD. This format is an international standard, and there is no way that dates formatted in this way can be misinterpreted.
Hi Darren, thanks for the reply.
I basically imported an old spreadsheet from google sheets for this project. I get what you mean about the ambiguity.
Is there any way I can correct those dates that are ambiguous? There are some 10,000 entries.
OK sussed it… exported the data, changed the format of the date columns, then re-imported it.
thank you!
Yes, that would have been my suggestion 