Glide can now format your :calendar: date and :alarm_clock: time columns, in the app user’s language, very similar to how number formats work: [2020-03-17 19.14.58] 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 t…

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 thems…

@John_Cabrera Not yet, unfortunately.

No problem. This is still quite epic. And a stepping stone for those kinds of additions, I’m sure.

[image] Robert_Petitto: current time date column Can you explain this one a little more? I looked at your feature request, but I’m not sure I understand how it would work.

Like a “single value” column but it outputs (and updates) current date time. Doesn’t get pulled from the sheet…Glide provides.

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 sho…

@emilio Could you share your app, please, and tell me how to get to that screen?

Thanks @Mark . Here’s my app demo-english.glideapp.io . To get to that screen go to the Messages tab > “New Mexican Restaurant” post.

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?

📆 Date/time formats

General

Jeff_Hager March 24, 2020, 1:05pm 11

How would you use it?

Time control

Topic		Replies	Views
Date format locale struggle: sheet vs app Ask for Help	42	2586	February 13, 2022
Data written to spreadsheet from app as Text format not Time format Ask for Help	21	1159	January 10, 2023
Date & Time Format Issues Ask for Help	28	1732	December 21, 2022
Hello, and, On Extending Glide with Google Apps Script Ask for Help	36	4976	February 27, 2022
Change Date Format Ask for Help	27	3675	February 23, 2021

📆 Date/time formats

Related topics