Glide apps only reading m.d.y date and not d.m.y?

Ask for Help
1

I want to accomplish to get the calendar to have the European date format.
However it only responses to the American way.

I want to accomplish
6.4.2020 (6. April)
8.4.2020 (8. April)

also, when I type in “6. April 2020” in Google Sheets, in Glides that becomes “1. April 2020”?

Run through here: https://www.loom.com/share/21fe61f976944121a168b2824dfdca56

Thank you!

2

I think I remember Glide saying that for now dates need to be entered in MM/DD/YYYY format. YYYY/MM/DD and ISO should work too. In they future I think they will try to get the region settings from the sheet.

Does the date show correctly on a phone? The calendar uses the device’s regional local settings for displaying the date. The same app will show the differently in the US compared to Europe. What region is your browser set to?

I would set the date in US, Y/M/D, or ISO in the sheet, then adjust the formatting of the date in the data tab.

3

Thank you Jeff. Yes, switched everything to US meanwhile and did a Zapier formatter inbetween before using the date outside of Glide.

Appreciate you following up on this!

1 Like
4

Mark said that probably tomorrow it could be solved

5

Doesn’t seam to be solved yet? I’m having the exact same problems.

6

Did you try formatting it in the Sheets instead of Glide, what did it show in Glide after you format everything the way you want in Sheets?

7

I don’t know if Glide has changed anything regarding what I mentioned earlier. If dates are coming from a glide date picker, then you should be fine, but if you are manually typing dates in your sheet, then sometimes they can be recognized in USA format. I always stress, especially when entering dates manually in the sheet, to make sure you are using mm/dd/yyyy or yyyy/mm/dd. I personally haven’t had any of these issues, so I don’t know how others have worked around it. It seems to be less of a problem compared to several months ago, so something must have been fixed. If you have any screenshots from your sheet and the glide editor, that might help. Also try to include shots of the date settings in the glide editor and what you have set for the column formatting in the sheet. Also the underlying value when you click on a date cell in the google sheet.

1 Like