For the time being, you still need to put your date/times in your spreadsheet in US format (month/day/year), but we will soon make that unnecessary, too.
Please let us know what you think, and if you run into any issues.
Excellent. Can we make Glide columns that duplicate the data in a Date/Time column and format that column the same (like using Template or If - Then - Else)? If we want two different columns with different visual formats in the app. Or is there a way to change date formatting in the components themselves yet?
Hi, I recently updated my date and time column and everything worked great, except the data isn’t showing up on the downloaded app on my phone. It’s viewable from the app on my desktop, but not the one on my phone. I already deleted it and downloaded again, but nothing.
Any ideas why data isn’t showing? Here are some screenshots…
I see. I’m guessing this is because Safari can’t parse the date you have in your spreadsheet, but Chrome can (we’ll fix this problem soon). What’s in your sheet in that column?
Emilio, I had that problem as well. Check your date format in your Google Sheet, it should be MM/DD/YYYY… I had it as DD/MM/YYYY and safari, for some reason, couldn’t read it.
It happened to me as well… for some reason, after selecting the date column and reformatting it to MM/DD/YYYY, it got fixed. But this is definitely something that shouldn’t happen!