I had seen it in staging the other day. I was surprised that it was in production.
1 Like
Hi @Mark,
In my gsheet, I have set all dates using the UI format as advised, even if my app is French (and so dd/mm/yyyy instead of mm/dd/yyyy).
In the data editor, I see my date column and I apply the âshortâ dat (only) format. It appears correctly in the dd/mm/yyyy format. Thatâs ok, and alo OK when the date is displayed by text components within my app.
But, using a bar chart, I noticed a bug : dates format is not managed correctly. See hereafter what happens :
Displayed as âtextâ, the date is correct, I mean in the expected format (dd/mm/yyyy). But using graph, US formatâŚ
Thereâs probably a way to work around this problem, by casting these dates as text in the correct format. But my app is going to be full of data soon, so if I can avoid to add non necessary data in the sheet, it would be better for meâŚ
Anyway, I dont put lot of pressure for this problem, itâs not so critical : I can explain to end users.
Christophe
I see the bug. Weâll fix it. Thank you for reporting!
2 Likes
Hi @Mark,
There have been issues with Date/Time formats for the last few days. Itâs causing some serious issues with an app Iâm relying on for scheduling purposes. Formats are getting changed, seemingly for no reason. My Sheetâs array formulas arenât even able to get the formatting corrected in the sheet, which is leading to relations not matching, etc etc.
Can someone look at this asap? Iâd be happy to provide access to my app to an admin who can look at the issues through a private message (as the app has private information).
Thank you
I have the same problem, my date format is DD/MM/YYYY in the first picture using calendar the date is displayed with MM/DD/YYYY the second picture it is correctly displayed.
Hi, had the same problem earlier this week, and changing the Spreadsheet Settings outlined here solved the issue for me. https://docs.glideapps.com/all/reference/components/pickers/date-time#date-formats-and-locales
For some reason, both my Locale and Time Zone were both set to London, even though I live in the U.S. So, I changed them both to U.S. (where I live) and problem was solved.
Hereâs another place in the documentation that talks about this: https://docs.glideapps.com/all/reference/using-sheets/sheets-faq#im-having-problems-with-date-and-time-formatting
Let me know if this worksâŚ
See this post below, and let me know if changing the Spreadsheet Settings works, as outlined here by Glide staff: đ Date/time formats
In my case not work correctly, because my location is Brazil, and my time zone is (GMT-03:00) SĂŁo Paulo
Thanks
1 Like
The change we pushed on Tuesday is that Glide will now read the underlying date/time value for date/time columns which have a format set in the Data Editor.
In other words, if you have a date/time column which you have formatted in Glide, Glide will now ignore the format in your spreadsheet and will read the underlying value.
If somebody could share the app thatâs showing weird behavior that would be very helpful. Please let me know what you expect to see, and what youâre actually seeing.
1 Like
Can Glideâs Date/Time formats be standardized to one format â and not change based on a userâs location? I have relations based on formulas that seem to break if the app receives values from users who are in different locations that use different default date formats.
Are you sure thatâs the case? Can you show me what you see in the spreadsheet?
âŚfollowing this thread!
Itâs more in the Editor. When I created my app on my laptop, my dates were added as â2020-04-07â for example.
When I opened the Editor on my phone to make a quick update, my dates in the Editor were in â04/07/2020â format. This caused a relation I created based on the YYYY-MM-DD format to break.
Thinking about it⌠itâs possible that my laptop thinks itâs American, but my phone thinks itâs Canadian. That being said, the Locale of my spreadsheet doesnât change, but the Glide Editor formats may be based on the deviceâs locale now and not the spreadsheetâs.
For this reason, I think the Editor needs to use a consistent format (like M/D/YYYY) in order to ensure any other columns that may depend on the date format are consistently calculated and wonât break if the Editor is opened on a device that is configured in a different locale.
This may only be an issue in the Editor though, as submissions are still saved in the format of the sheet. The Editorâs displayed formats though are based on the deviceâs locale (I think) which causes inconsistencies. Sorry for the long-winded explanation. This is tough to test if all the testing is done in one area, so it could be complicated to determine (and explain) the underlying issue.
Whatâs shown in Data Editor are the formatted values, according to the language you have set on your device/browser. Whatâs used to compute relations, however, are the underlying values, which are independent of your locale.
Are you saying thatâs not what youâre seeing? That relations are computed differently dependent on the browserâs language?
My relation is based on a formula in my sheet that converts a date to text using a formula (i.e. text(A2, "M/D/YYYY))
If the Editor is opened in a different locale, this formula breaks and my date formats in the other column that my formula is trying to match are now not in M/D/YYYY Format, but rather in YYYY-MM-DD for example.
What if your sheet formula formulated the date in such a way that Glide would not recognize it as a date. maybe throw in some extra characters or use something other that / or - in the date. Make it look like âxxxxM/D/YYYYâ or âM#D#YYYYâ
If Glide matches dates based on the format you have set in the Data Editor, thatâs bug. Could you please share your app with me and tell me exactly how to reproduce this issue?
PM sent.
Ah, I see what youâre doing. The source column for the match is not a date/time column, but a Template that includes a date/time, which means that the localized date format becomes âbaked inâ.
Is there a reason why you canât match against the original date/time column? Are the values not exactly equal?