Hi, I’ve found a bug in date/time format component. In special with Special component current date/time, that is very useful to automatically update modifications date/time. My locale is set to Spain…dd/mm/yyyy, and the format in the google sheet date columns too. When I update some field, I put …

I still believe if Glide switched to storing dates in ISO format(YYYYMMDD), that would solve a lot of problems for people. It’s an international standard recognized by Google and Glide and compatible across all countries. This still allows people to reformat the date into a new column if the user …

I also need df/mm/yyyy and suffer from the problem in Israel

I had requested this option in a previous post some time ago [image] I would like to include in the date / time or date component an option to format the date by country Feature Requests I would like to include in the date / time or date component an option to format the …

No, it’s not possible. That’s why I put this message. As I have shown in the example (in the images) when Glide writes, it writes in the English format (mm/dd/yyyyy). Of course if you manually reformat the column is shown properly, but if you edit it again Glide records it badly…the problem is seri…

@jrox10 Sorry if you misunderstood, I wasn’t offering a suggestion for you to solve your problem. I was offering a suggestion for Glide to store the dates in YYYYMMDD. I think this would solve everybody’s problem.

We could do ISO date/time format, which would be like 2017-03-13T15:00:00.000Z.

@Mark I think Google has issues with recognizing true ISO as a date, but with the limited testing I’ve done, I think replacing the T and Z with spaces would work. Basically the same format you already use, but moving the year to the front.

I think we have to differentiate between the way in which the date is saved and the way in which it is represented. A good model is like Google sheet (I attach an image…). [07] The problem now is that for days between 01 and 12, it is not clear what is being represented…for example if glideapps s…

@jrox10 If Glide stored the date as YYYYMMDD, Google would recognize what is year, what is month, and what is day regardless of with country you are in. The calendar component also recognizes this format correctly. This would help solve the issue with days 1 through 12. It would also allow for e…

@Mark my only concern with switching the date format would be if people are using a substring method to parse the date into a new column vs Text(). I wonder if it would be better to allow people to select a global date format for the app so they can choose if and when they want to change the format…

Bad format special component current date/time

Report a Bug

Alex_Calandrino October 7, 2019, 1:17pm 4

I had requested this option in a previous post some time ago

Topic		Replies	Views
Date format component Report a Bug	4	743	January 7, 2021
I would like to include in the date / time or date component an option to format the date by country Feature Requests	4	742	February 11, 2021
📆 Date/time formats General	82	7951	December 29, 2020
Date format locale struggle: sheet vs app Ask for Help	42	2761	February 13, 2022
:exploding_head: I cant with the dates! Ask for Help	11	1368	November 22, 2021

Bad format special component current date/time

Related topics