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…

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 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 :face_with_symbols_over_mouth: :face_with_symbols_over_mouth: :face_with_symbols_over_mouth: [image] This then shows crap b…

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

You didn’t add a link. In that screenshot you show 5 columns, WorkedTime, …, Date. Which ones of those are written by the app?

@Mark , All the details were sent in responding to the mail I received. This has then appeared as a post with much of the content redacted. Do you want all the details posted to this forum for open consumption or do you have a more direct method to communicate? Regards Pat

I don’t know what email you’re referring to. You could tell me which of those 5 columns are written by Glide, vs calculated in the spreadsheet.

@Mark , Mail Firstly the mail which I presume is an automated part of this forum, subject : Re: [Glide Community] [Announcements] :calendar: Date/time formats from : Glide Community glideapps+8234b7bdd74213796c21239632497b68@discoursemail.com My response with details redacted is what appears her…

📆 Date/time formats

General

Pat_Baker October 7, 2020, 3:44pm 67

Hi Mark,

The app is :

e.g last row added through the app

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

📆 Date/time formats

Related topics