Change in the way column date data are handled

[Darren_Murphy]

@Thibault_Milan

For a couple of weeks now, the date inserted from this column is now in yyyy-MM-dd'T'HH:mm:ss.SSS'Z' format instead of YYY-MM-DD breaking a lot of formulas for me

The only way I’ve found to reliably deal with this is via a script:

Scripts, scripts, scripts!

Fixing broken timestamps I’m sure I’m not the first to notice this, but the “timestamps” that Glide inserts into GSheets often get interpreted as strings. When this happens, any date/time formatting that you try to apply will fail, and you end up with an ugly looking set of characters masquerading as an ISO-8601 datetime (except it isn’t ) This has been doing my head in recently, and it finally got the better of me and I decided to deal with it once and for all. T…

But… you mention that this breaks formulas. I would encourage you to investigate the option of moving those formulas out of your Google Sheets and into the Glide Data Editor.