Glide can now format your :calendar: date and :alarm_clock: time columns, in the app user’s language, very similar to how number formats work: [2020-03-17 19.14.58] For the time being, you still need to put your date/times in your spreadsheet in US format (month/day/year), but we will soon make t…

[image] 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 …

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

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 wil…

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?

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. T…

📆 Date/time formats

General

kyleheney April 9, 2020, 11:36pm 45

I posted this issue in another thread: Pretty Timestamp not displaying in Tile Caption

Topic		Replies	Views
Date format locale struggle: sheet vs app Ask for Help	42	2612	February 13, 2022
Data written to spreadsheet from app as Text format not Time format Ask for Help	21	1174	January 10, 2023
Date & Time Format Issues Ask for Help	28	1732	December 21, 2022
Hello, and, On Extending Glide with Google Apps Script Ask for Help	36	4979	February 27, 2022
Change Date Format Ask for Help	27	3681	February 23, 2021

📆 Date/time formats

Related topics