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?
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
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?
Can you share a few lines of the CSV file?
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?
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.
As in actual file or just a cut paste of screen?
The actual file.
Ok thanks.
I’ve found this when I googled changing dates in excel so I will try it and then see how it imports.
- Select the Cell(s): Choose the cell(s) containing the date you want to format.
- 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).
Ok will do. Stand by!
Hope this works:
ok, I will try that formula I posted above.