# Issue with AU dates turning into US dates **URL:** \ **Category:** Ask for Help\ **Created:** [July 22, 2025, 7:00am UTC](https://community.glideapps.com/t/issue-with-au-dates-turning-into-us-dates/83355 "2025-07-22T07:00:30Z")\ **Posts on this page:** 13\ **Page:** 1
**Author:** ![SageCat](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/sagecat/32/85273_2.png) [@SageCat](https://community.glideapps.com/u/SageCat)\ **Post date:** [July 22, 2025, 7:00am UTC](https://community.glideapps.com/t/issue-with-au-dates-turning-into-us-dates/83355/1 "2025-07-22T07:00:30Z")
Hi all. I"m moving data from one app to another. In original app it is showing dates correctly in AU format. I export data, then import data into a new app and the dates have moved to US! How can I fix this and stop it from doing this please? ---
**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:** [July 22, 2025, 7:19am UTC](https://community.glideapps.com/t/issue-with-au-dates-turning-into-us-dates/83355/2 "2025-07-22T07:19:32Z")
This is a common issue. The problem is that when you have an ambiguous date, Glide will always default to US format. For example, consider the 11th of January. In Australia, you might write that as 11-01-2025. And in the US it would be written as 01-11-2025. When Glide sees 11-01-2025, it doesn’t know if it should be US or AU format, and so it assumes US format, and you wind up with 1st November. The way to work around this is to always use the international standard (ISO-8601) of date formatting when importing date values. That is, YYYY-MM-DD. Dates formatted that way can never be ambiguous or misinterpreted. If you also have time values, then you should include a TZ offset value, eg. `2025-01-11T09:00:00+11:00` > **[ISO 8601](https://en.wikipedia.org/wiki/ISO_8601)** > > 2025-07-22T03:15:01+00:00 UTC+00:00 > ISO 8601 is an international standard covering the worldwide exchange and communication of date and time-related data. It is maintained by the International Organization for Standardization (ISO) and was first published in 1988, with updates in 1991, 2000, 2004, and 2019, and an amendment in 2022. The standard provides a well-defined, unambiguous method of representing calendar dates and times in worldwide communications, especially to avoid misinterpreting nu... ---
**Author:** ![SageCat](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/sagecat/32/85273_2.png) [@SageCat](https://community.glideapps.com/u/SageCat)\ **Post date:** [July 22, 2025, 7:31am UTC](https://community.glideapps.com/t/issue-with-au-dates-turning-into-us-dates/83355/3 "2025-07-22T07:31:31Z")
Ok so I exported from original Glide app that was in AU dates, checked in csv file to make sure dates good, imported into new Glide app and now they are US. How should I be exporting to ensure they stay AU when imported? ---
**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:** [July 22, 2025, 7:32am UTC](https://community.glideapps.com/t/issue-with-au-dates-turning-into-us-dates/83355/4 "2025-07-22T07:32:59Z")
Can you share a few lines of the CSV file? ---
**Author:** ![SageCat](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/sagecat/32/85273_2.png) [@SageCat](https://community.glideapps.com/u/SageCat)\ **Post date:** [July 22, 2025, 7:43am UTC](https://community.glideapps.com/t/issue-with-au-dates-turning-into-us-dates/83355/5 "2025-07-22T07:43:36Z")
I’ve googled about the dates and found how to change setting in windows. So would best practice when moving data tables like this be to change windows to ISO date format, export data, import data and then set back to regular date format? ---
**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:** [July 22, 2025, 7:45am UTC](https://community.glideapps.com/t/issue-with-au-dates-turning-into-us-dates/83355/6 "2025-07-22T07:45:52Z")
Just make sure the dates are formatted as YYYY-MM-DD in your CSV file. You don’t have to change anything after importing. As long as the dates are correct, Glide will use your device settings to format the dates correctly. ---
**Author:** ![SageCat](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/sagecat/32/85273_2.png) [@SageCat](https://community.glideapps.com/u/SageCat)\ **Post date:** [July 22, 2025, 7:48am UTC](https://community.glideapps.com/t/issue-with-au-dates-turning-into-us-dates/83355/7 "2025-07-22T07:48:14Z")
As in actual file or just a cut paste of screen? ---
**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:** [July 22, 2025, 7:50am UTC](https://community.glideapps.com/t/issue-with-au-dates-turning-into-us-dates/83355/8 "2025-07-22T07:50:11Z")
The actual file. ---
**Author:** ![SageCat](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/sagecat/32/85273_2.png) [@SageCat](https://community.glideapps.com/u/SageCat)\ **Post date:** [July 22, 2025, 7:59am UTC](https://community.glideapps.com/t/issue-with-au-dates-turning-into-us-dates/83355/9 "2025-07-22T07:59:27Z")
Ok thanks. I’ve found this when I googled changing dates in excel so I will try it and then see how it imports. 1. **Select the Cell(s):** Choose the cell(s) containing the date you want to format. 2. **Enter the Formula:** In a new cell (or the same cell after backing up the original value), enter the following formula: `=TEXT(A1,"yyyy-mm-dd")` (Replace A1 with the actual cell reference). 1. ---
**Author:** ![SageCat](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/sagecat/32/85273_2.png) [@SageCat](https://community.glideapps.com/u/SageCat)\ **Post date:** [July 22, 2025, 8:00am UTC](https://community.glideapps.com/t/issue-with-au-dates-turning-into-us-dates/83355/10 "2025-07-22T08:00:42Z")
Ok will do. Stand by! ---
**Author:** ![SageCat](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/sagecat/32/85273_2.png) [@SageCat](https://community.glideapps.com/u/SageCat)\ **Post date:** [July 22, 2025, 8:06am UTC](https://community.glideapps.com/t/issue-with-au-dates-turning-into-us-dates/83355/11 "2025-07-22T08:06:11Z")
Hope this works: > **[For Darren.csv](https://drive.google.com/file/d/1u6hdC6S6WxfRuX--KUjyvlqjQMPxFGEq/view?usp=sharing)** > > Google Drive file. ---
**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:** [July 22, 2025, 8:09am UTC](https://community.glideapps.com/t/issue-with-au-dates-turning-into-us-dates/83355/12 "2025-07-22T08:09:05Z")
Yes, the dates in your CSV are formatted as DD/MM/YYYY ![CleanShot 2025-07-22 at 16.07.52@2x](https://us1.discourse-cdn.com/flex002/uploads/glideapps/original/3X/b/f/bf35d16ca9eadac56041a907976254c89ac0a467.png) You need to change them to YYYY-MM-DD ---
**Author:** ![SageCat](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/sagecat/32/85273_2.png) [@SageCat](https://community.glideapps.com/u/SageCat)\ **Post date:** [July 22, 2025, 9:57am UTC](https://community.glideapps.com/t/issue-with-au-dates-turning-into-us-dates/83355/13 "2025-07-22T09:57:05Z")
ok, I will try that formula I posted above.