# Date format keeps changing **URL:** \ **Category:** Ask for Help\ **Created:** [September 12, 2025, 9:06am UTC](https://community.glideapps.com/t/date-format-keeps-changing/84343 "2025-09-12T09:06:01Z")\ **Posts on this page:** 6\ **Page:** 1
**Author:** ![Tony\_Goodman](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/tony_goodman/32/90798_2.png) [@Tony\_Goodman](https://community.glideapps.com/u/Tony_Goodman)\ **Post date:** [September 12, 2025, 9:06am UTC](https://community.glideapps.com/t/date-format-keeps-changing/84343/1 "2025-09-12T09:06:01Z")
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? ---
**Author:** ![Darren\_Murphy](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/darren_murphy/32/47326_2.png) [@Darren\_Murphy](https://community.glideapps.com/u/Darren_Murphy)\ **Post date:** [September 12, 2025, 9:21am UTC](https://community.glideapps.com/t/date-format-keeps-changing/84343/2 "2025-09-12T09:21:49Z")
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. ---
**Author:** ![Tony\_Goodman](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/tony_goodman/32/90798_2.png) [@Tony\_Goodman](https://community.glideapps.com/u/Tony_Goodman)\ **Post date:** [September 12, 2025, 9:33am UTC](https://community.glideapps.com/t/date-format-keeps-changing/84343/3 "2025-09-12T09:33:13Z")
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. ---
**Author:** ![Tony\_Goodman](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/tony_goodman/32/90798_2.png) [@Tony\_Goodman](https://community.glideapps.com/u/Tony_Goodman)\ **Post date:** [September 12, 2025, 9:43am UTC](https://community.glideapps.com/t/date-format-keeps-changing/84343/4 "2025-09-12T09:43:47Z")
OK sussed it… exported the data, changed the format of the date columns, then re-imported it. thank you! ---
**Author:** ![Darren\_Murphy](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/darren_murphy/32/47326_2.png) [@Darren\_Murphy](https://community.glideapps.com/u/Darren_Murphy)\ **Post date:** [September 12, 2025, 9:44am UTC](https://community.glideapps.com/t/date-format-keeps-changing/84343/5 "2025-09-12T09:44:34Z")
Yes, that would have been my suggestion 👍 ---
**Author:** ![system](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/system/32/53398_2.png) [@system](https://community.glideapps.com/u/system)\ **Post date:** [September 19, 2025, 9:44am UTC](https://community.glideapps.com/t/date-format-keeps-changing/84343/6 "2025-09-19T09:44:51Z")
This topic was automatically closed 7 days after the last reply. New replies are no longer allowed.