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…

No worries…actually, it would be neat if you could “assign” column types (template >> Date/Time), Lookup >> Math/Template (for units), etc. Not sure if it solves this issue.

Yes, we’ll have to make it possible to assign different formats in computed columns.

Fixed! And correct dates order now, even for non US format dates. Many thanks! [Screenshot_20200412_065107_com.android.chrome]

Hi all, in my Google Sheet I apply a particular date/time format to my date column and Glide app displays it nicely. (see green boxes) But when Glide adds new rows to the spreadsheet, the newly inserted date loses the format and in Glide’s app the date is not correctly displayed (see red boxes). …

Similar issue reported here: Format of column not sticking when new rows added to sheet I was able to create a script that runs onChange that changes every date column to the appropriate format and doesn’t rely on Glide or the Sheet to copy down the formatting when new rows are added.

@Mark Can the date/time formats in the Glide Data Editor also allow 24hr formats not just AM / PM, as is available in the actual Sheets formatting? Thanks

@Pat_Baker Which columns in that sheet are written by Glide?

[image] Pat_Baker: Can the date/time formats in the Glide Data Editor also allow 24hr formats not just AM / PM, as is available in the actual Sheets formatting? If you set a date format in the Data Editor, it will use 12 or 24 hour format depending on the locale set by the user of the app, an…

Hi Mark, The app is : e.g last row added through the app

📆 Date/time formats

General

Pat_Baker October 6, 2020, 6:27pm 63

@Mark

Same issue as the post above where Glide writes back to the sheet to a column populated with an array formula and a format that works perfectly and screws it all over

This then shows crap back to user rather than the perfectly formatted data.

Topic		Replies	Views
Date format locale struggle: sheet vs app Ask for Help	42	2613	February 13, 2022
Data written to spreadsheet from app as Text format not Time format Ask for Help	21	1174	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	4980	February 27, 2022
Change Date Format Ask for Help	27	3683	February 23, 2021

📆 Date/time formats

Related topics