@Daniel_Lozano couldnāt get it to work, unfortunatelyā¦ but I can wait for a fix. Thanks for helping out.
@Mark if it helps, I recorded a test post on my phone and you can see how the timestamp initially displays but quickly disappears after a few seconds. Thanks again!
This should be fixed later today.
Lol! I agree with you on that @Rosewebstudio
Hi @Mark Please when will be unnecessary to have dates in US format??
Hope soon is close. Thanks!!
Probably Tuesday.
Thank you so much! I had posted about this yesterday, requesting this feature. Itās no longer displaying 24-hr format for user upon clicking on calendar event. Appreciate it!
Have you guys noticed too how Sheets displays the calendar? So in Glide, it displays the correct date that I entered in Sheets: April 2, 2020. But in Sheets, it reverses the month and day to show it like this. I know this isnāt a Glide issue, but kind of confusingā¦
Soā¦in data editor with theā¦ if then columnā¦ when ā¦if date is within todayā¦ it takes dates 4 March instead today 3 Abril.
It is supposed this will be consequently working ok probably on Tuesday.
Right @Mark ??
Thanks
The same thing happened to @kyleheney with my Meet With Me app:
Iām having a Date/Time issue.
I have a Choice Component that has the user selecting a date field ---- the sheet where the choices are stored is recognizing this column as a Date field in the Editor.
When the user submits a response and the Date field is recorded using a āColumnā component to capture the selected date, the response is recorded in a text format and not a date format. In the Editor, my Responses sheet then displays this field as a text column and not a date column. Because of this, I cannot apply a date filter to the responses, as itās recognized as a text field and not a date field.
If I change the formatting in my spreadsheet for the Date column on my Responses sheet, it updates the current values to a Date format, but anything submitted afterwards gets inserted into my sheet as a piece of text (i.e. 'March 31, 2020).
Right. I noticed this too.
Yepā¦ Also for graph, same problem.
Thanks for reporting this. Weāll look into it.
@Christophe_HK What do you mean āgraphā?
Glide lets you create new columns now and define the type right away in the data tab. Looks like you can plug in a date and itās recognized as a date. Try that once.
Unless itās how you have the date formatted in the choice component. I just tried typing a date in a text box and that seemed fine, but it looked like this ā3/14/2020 20:55:00ā
I saw that! I had to do a double take and wonder if I had missed that all along.
I had seen it in staging the other day. I was surprised that it was in production.
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!
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.