# Problem with dates when uploading database **URL:** \ **Category:** Report a Bug\ **Tags:** data-sync\ **Created:** [April 17, 2024, 8:17pm UTC](https://community.glideapps.com/t/problem-with-dates-when-uploading-database/72674 "2024-04-17T20:17:36Z")\ **Posts on this page:** 14\ **Page:** 1
**Author:** ![Alan8a](https://avatars.discourse-cdn.com/v4/letter/a/e274bd/32.png) [@Alan8a](https://community.glideapps.com/u/Alan8a)\ **Post date:** [April 17, 2024, 8:17pm UTC](https://community.glideapps.com/t/problem-with-dates-when-uploading-database/72674/1 "2024-04-17T20:17:36Z")
When I load a database with dates it completely changes them, not only year but also month and day. I’ve checked and they have the same format as used in the app. Is anyone else experiencing this issue as well? ---
**Author:** ![ThinhDinh](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/thinhdinh/32/49_2.png) [@ThinhDinh](https://community.glideapps.com/u/ThinhDinh)\ **Post date:** [April 17, 2024, 11:42pm UTC](https://community.glideapps.com/t/problem-with-dates-when-uploading-database/72674/2 "2024-04-17T23:42:04Z")
I think @Darren_Murphy reported this a few days ago but not sure any updates have been made since then. ---
**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:** [April 18, 2024, 1:57am UTC](https://community.glideapps.com/t/problem-with-dates-when-uploading-database/72674/3 "2024-04-18T01:57:42Z")
Yes, I have some experience with this. @Alan8a - exactly how are you loading the data? And what format are your dates in? Can you provide a sample please? ---
**Author:** ![Mns\_Glide](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/mns_glide/32/2514_2.png) [@Mns\_Glide](https://community.glideapps.com/u/Mns_Glide)\ **Post date:** [April 18, 2024, 4:27am UTC](https://community.glideapps.com/t/problem-with-dates-when-uploading-database/72674/4 "2024-04-18T04:27:51Z")
I also having a strange issue as well. My data is from excel and formatted as 1980-04-05 (yyyy-mm-dd). When I upload 1. on display it shows 04-04-1980 ![d1](https://us1.discourse-cdn.com/flex002/uploads/glideapps/original/3X/d/c/dc6e09ecc30f8bc7f91fc17908fea5cac190f573.jpeg) 1. when I click into the date cell, it shows 05-04-1980 (correctly) ![d1a](https://us1.discourse-cdn.com/flex002/uploads/glideapps/original/3X/a/d/ad0ffdb1db0767a21f3e18304247312696972241.jpeg) Turning on/off “Respect timezone” makes no difference. Appreciate any insight. Thanks. ---
**Author:** ![Alan8a](https://avatars.discourse-cdn.com/v4/letter/a/e274bd/32.png) [@Alan8a](https://community.glideapps.com/u/Alan8a)\ **Post date:** [April 18, 2024, 5:41am UTC](https://community.glideapps.com/t/problem-with-dates-when-uploading-database/72674/5 "2024-04-18T05:41:56Z")
I’ve downloaded a table from another Glide app and imported it. The dates when downloading look like this, however when checking the dates actually submitted most of them en un being dates that haven’t even ocurred yet, like november 2024 or december 2025. ![Captura de Pantalla 2024-04-17 a la(s) 23.39.36](https://us1.discourse-cdn.com/flex002/uploads/glideapps/original/3X/6/f/6f0056b4ae21d0410a051b2902974ce0196f58a4.png) ---
**Author:** ![Alan8a](https://avatars.discourse-cdn.com/v4/letter/a/e274bd/32.png) [@Alan8a](https://community.glideapps.com/u/Alan8a)\ **Post date:** [April 18, 2024, 5:42am UTC](https://community.glideapps.com/t/problem-with-dates-when-uploading-database/72674/6 "2024-04-18T05:42:40Z")
Thank you, appreciate the reply ---
**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:** [April 18, 2024, 5:49am UTC](https://community.glideapps.com/t/problem-with-dates-when-uploading-database/72674/7 "2024-04-18T05:49:10Z")
Before importing them, try reformatting them as [ISO8601](https://en.wikipedia.org/wiki/ISO_8601) datetime strings: ```auto YYYY-MM-DDTHH:MM:SS ``` So, taking your first example, it would be: ```auto 2023-07-29T14:36:35 ``` ---
**Author:** ![Alan8a](https://avatars.discourse-cdn.com/v4/letter/a/e274bd/32.png) [@Alan8a](https://community.glideapps.com/u/Alan8a)\ **Post date:** [April 18, 2024, 6:06am UTC](https://community.glideapps.com/t/problem-with-dates-when-uploading-database/72674/8 "2024-04-18T06:06:26Z")
I’ll try that and let you know thank you ---
**Author:** ![Mns\_Glide](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/mns_glide/32/2514_2.png) [@Mns\_Glide](https://community.glideapps.com/u/Mns_Glide)\ **Post date:** [April 18, 2024, 6:41am UTC](https://community.glideapps.com/t/problem-with-dates-when-uploading-database/72674/9 "2024-04-18T06:41:03Z")
> [@Darren\_Murphy](#): > > [ISO8601](https://en.wikipedia.org/wiki/ISO_8601) datetime strings I had reformatted to suggested but still the same error as I highlighted. I think this is a bug that needs someone at Glide to look at. How do I raise a support? or there is someone looking at the bug? TQ ---
**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:** [April 18, 2024, 6:47am UTC](https://community.glideapps.com/t/problem-with-dates-when-uploading-database/72674/10 "2024-04-18T06:47:20Z")
I have an open ticket, although the issues I’ve had are slightly different. In your case, the date is off by one, yes? It looks like it may be applying your local UTC offset when importing the dates. Try it using the following: ```auto 1980-04-05T00:00:00Z ``` The `Z` on the end should force Glide to use the date/time as presented without applying any offset correction. ---
**Author:** ![Mns\_Glide](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/mns_glide/32/2514_2.png) [@Mns\_Glide](https://community.glideapps.com/u/Mns_Glide)\ **Post date:** [April 18, 2024, 7:02am UTC](https://community.glideapps.com/t/problem-with-dates-when-uploading-database/72674/11 "2024-04-18T07:02:05Z")
it still does not display properly. it is as I had described with photos before. When I click into the cell, the date is correct. But when you exit the cell, it reads a day behind. In the if-then-else column, it shows the correct date. In the same file, I have another 2 columns of dates which is in format of dd/mm/yyyy and they are imported ok. However, these columns, for whatever reasons, I cannot reformat in excel. TQ ---
**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:** [April 18, 2024, 7:52am UTC](https://community.glideapps.com/t/problem-with-dates-when-uploading-database/72674/12 "2024-04-18T07:52:05Z")
> [@Mns\_Glide](#): > > n the if-then-else column, it shows the correct date. If-then-else column? > [@Mns\_Glide](#): > > In the same file, I have another 2 columns of dates which is in format of dd/mm/yyyy and they are imported ok. However, these columns, for whatever reasons, I cannot reformat in excel. I don’t know anything about Excel, sorry. Another thing you can do is convert to ODS format, and import that. I’ve been told that using ODS for imports is more reliable than other formats. ---
**Author:** ![Mns\_Glide](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/mns_glide/32/2514_2.png) [@Mns\_Glide](https://community.glideapps.com/u/Mns_Glide)\ **Post date:** [April 19, 2024, 10:54pm UTC](https://community.glideapps.com/t/problem-with-dates-when-uploading-database/72674/13 "2024-04-19T22:54:10Z")
ODS does not work either. Seems only way is to format as yyyy-mm-dd and then add 1 day and then import. Really awkward way to do it. ---
**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:** [October 16, 2024, 10:54pm UTC](https://community.glideapps.com/t/problem-with-dates-when-uploading-database/72674/14 "2024-10-16T22:54:37Z")
This topic was automatically closed 180 days after the last reply. New replies are no longer allowed.