I noticed that I have a little problem with my app. Basically, an admin can create events, and people can receive a mail when they can grab a spot for the event. When creating the event, there is date/time pickers for 2 things : the day when they can save a spot, and the event itself.
When I’m picking dates, the date/time picker is showing dates in a French format : dd/mm/yyyy.
But, there is the problem : when I’m using this data in the app, the app will consider it as a US format date : mm/dd/yyyy.
Is there any settings allowing me to change from US to French format ? Or can Glide automatically use a locked format for dates in the app ?
Yeah, this seems like it would be solved with our experimental new date code.
@MaximeDeconinck We tried enabling a fix a few weeks ago, but this broke a bunch of apps and we had to revert it. We’re still working on testing it unfortunately. I recommend that you enable date formatting in the data editor for the time, this will correct your date problem immediately.
@MaximeDeconinck Can you share a support code with me on the forum? Only authorized Glide employees can access your app through these support codes, so feel free to post here or DM me.
I can’t seem to reproduce this on my own. Looking into your app internally, it seems that the date is actually correct. We sent the correct date to our own backend. I do see that the row in question has been updated lately. Is this still a problem as of the recent reload?
The problem is still there, but I think I just found something really interesting.
You probably saw it, but I’m using a details layout, an inline list with a calendar layout instead of just a regular calendar layout, but when I switch to the calendar layout, it appears that dates are know understood in a French format, which is really weird actually…
Maybe the problem is coming from the fact that it is an inline list that only uses US dates format (just guessing) ? I can’t really go for a regular calendar layout, because I’m using others components on this page, such as a link to the event’s creator.
The problem is that you are combining the date and the hour as text. You should consider finding an alternative to doing so, as date and time formats vary wildly from one computer to the next. Defaults for web browsers, regardless of localization settings, treat all attempts to read textual dates as US format. Trying to base this on localization is extremely fragile and will likely break.
Consider instead storing your data as a combined Date/Time format. You can control the format individually using the Math column; for Dates just refer to the combined Date/Time column, and for the Hour you may use our new HOUR() function over the same Date/Time column.
