# đ Date/time formats
**URL:** https://community.glideapps.com/t/date-time-formats/5719
**Category:** General
**Created:** [March 23, 2020, 3:22pm UTC](https://community.glideapps.com/t/date-time-formats/5719 "2020-03-23T15:22:23Z")
**Posts on this page:** 20
**Page:** 3
### Author:  [@spencerb](https://community.glideapps.com/u/spencerb)
#### Post date: [April 9, 2020, 3:12pm UTC](https://community.glideapps.com/t/date-time-formats/5719/41 "2020-04-09T15:12:17Z")
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](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](https://docs.glideapps.com/all/reference/using-sheets/sheets-faq#im-having-problems-with-date-and-time-formatting)
Let me know if this worksâŚ
---
### Author:  [@spencerb](https://community.glideapps.com/u/spencerb)
#### Post date: [April 9, 2020, 3:13pm UTC](https://community.glideapps.com/t/date-time-formats/5719/42 "2020-04-09T15:13:27Z")
See this post below, and let me know if changing the Spreadsheet Settings works, as outlined here by Glide staff: [đ Date/time formats](https://community.glideapps.com/t/date-time-formats/5719/41)
---
### Author:  [@Adalberto\_Ponzo](https://community.glideapps.com/u/Adalberto_Ponzo)
#### Post date: [April 9, 2020, 3:29pm UTC](https://community.glideapps.com/t/date-time-formats/5719/43 "2020-04-09T15:29:04Z")
In my case not work correctly, because my location is Brazil, and my time zone is (GMT-03:00) SĂŁo Paulo
Thanks
---
### Author:  [@Mark](https://community.glideapps.com/u/Mark)
#### Post date: [April 9, 2020, 11:07pm UTC](https://community.glideapps.com/t/date-time-formats/5719/44 "2020-04-09T23:07:39Z")
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.
---
### Author:  [@kyleheney](https://community.glideapps.com/u/kyleheney)
#### Post date: [April 9, 2020, 11:36pm UTC](https://community.glideapps.com/t/date-time-formats/5719/45 "2020-04-09T23:36:11Z")
I posted this issue in another thread: [Pretty Timestamp not displaying in Tile Caption](https://community.glideapps.com/t/pretty-timestamp-not-displaying-in-tile-caption/6609/3)
---
### Author:  [@kyleheney](https://community.glideapps.com/u/kyleheney)
#### Post date: [April 11, 2020, 1:05pm UTC](https://community.glideapps.com/t/date-time-formats/5719/46 "2020-04-11T13:05:56Z")
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.
---
### Author:  [@Mark](https://community.glideapps.com/u/Mark)
#### Post date: [April 11, 2020, 1:10pm UTC](https://community.glideapps.com/t/date-time-formats/5719/47 "2020-04-11T13:10:21Z")
Are you sure thatâs the case? Can you show me what you see in the spreadsheet?
---
### Author:  [@Robert\_Petitto](https://community.glideapps.com/u/Robert_Petitto)
#### Post date: [April 11, 2020, 1:12pm UTC](https://community.glideapps.com/t/date-time-formats/5719/48 "2020-04-11T13:12:40Z")
âŚfollowing this thread!
---
### Author:  [@kyleheney](https://community.glideapps.com/u/kyleheney)
#### Post date: [April 11, 2020, 1:51pm UTC](https://community.glideapps.com/t/date-time-formats/5719/49 "2020-04-11T13:51:11Z")
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.
---
### Author:  [@Mark](https://community.glideapps.com/u/Mark)
#### Post date: [April 11, 2020, 2:16pm UTC](https://community.glideapps.com/t/date-time-formats/5719/50 "2020-04-11T14:16:33Z")
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?
---
### Author:  [@kyleheney](https://community.glideapps.com/u/kyleheney)
#### Post date: [April 11, 2020, 2:19pm UTC](https://community.glideapps.com/t/date-time-formats/5719/51 "2020-04-11T14:19:03Z")
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.
---
### Author:  [@Jeff\_Hager](https://community.glideapps.com/u/Jeff_Hager)
#### Post date: [April 11, 2020, 3:14pm UTC](https://community.glideapps.com/t/date-time-formats/5719/52 "2020-04-11T15:14:13Z")
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â
---
### Author:  [@Mark](https://community.glideapps.com/u/Mark)
#### Post date: [April 11, 2020, 3:37pm UTC](https://community.glideapps.com/t/date-time-formats/5719/53 "2020-04-11T15:37:04Z")
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?
---
### Author:  [@kyleheney](https://community.glideapps.com/u/kyleheney)
#### Post date: [April 11, 2020, 5:18pm UTC](https://community.glideapps.com/t/date-time-formats/5719/54 "2020-04-11T17:18:45Z")
PM sent.
---
### Author:  [@Mark](https://community.glideapps.com/u/Mark)
#### Post date: [April 11, 2020, 5:38pm UTC](https://community.glideapps.com/t/date-time-formats/5719/55 "2020-04-11T17:38:56Z")
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?
---
### Author:  [@Robert\_Petitto](https://community.glideapps.com/u/Robert_Petitto)
#### Post date: [April 11, 2020, 5:48pm UTC](https://community.glideapps.com/t/date-time-formats/5719/56 "2020-04-11T17:48:32Z")
@kyleheney is using my Meet with Me template. I wanted 15 minute intervals onlyâchoice component. Template column merges selected date and time to form date/time. This datetime template feeds a form and this value is used in a few sheet calculations to determine conflicts. When the template datetime hits the responses sheet, Glide recognizes the value as a datetime.
  
---
### Author:  [@Mark](https://community.glideapps.com/u/Mark)
#### Post date: [April 11, 2020, 5:53pm UTC](https://community.glideapps.com/t/date-time-formats/5719/57 "2020-04-11T17:53:45Z")
Ah, I see the problem. You really want Glide to treat âSelected Dateâ as text, not as a date, so that it doesnât apply a format. Letting you pick the type of a basic column is on our to-do list, but unfortunately you canât do it right now. We werenât thinking of a use case like this when we introduced date/time formats.
---
### Author:  [@Robert\_Petitto](https://community.glideapps.com/u/Robert_Petitto)
#### Post date: [April 11, 2020, 6:08pm UTC](https://community.glideapps.com/t/date-time-formats/5719/58 "2020-04-11T18:08:06Z")
No worriesâŚactually, it would be neat if you could âassignâ column types (template \>\> Date/Time), Lookup \>\> Math/Template (for units), etc. Not sure if it solves this issue.
---
### Author:  [@Mark](https://community.glideapps.com/u/Mark)
#### Post date: [April 11, 2020, 6:17pm UTC](https://community.glideapps.com/t/date-time-formats/5719/59 "2020-04-11T18:17:13Z")
Yes, weâll have to make it possible to assign different formats in computed columns.
---
### Author:  [@Christophe\_HK](https://community.glideapps.com/u/Christophe_HK)
#### Post date: [April 12, 2020, 4:53am UTC](https://community.glideapps.com/t/date-time-formats/5719/60 "2020-04-12T04:53:56Z")
Fixed! And correct dates order now, even for non US format dates.
Many thanks!
[Previous page](https://community.glideapps.com/t/date-time-formats/5719.md?page=2)
[Next page](https://community.glideapps.com/t/date-time-formats/5719.md?page=4)