# Change in the way column date data are handled **URL:** \ **Category:** Ask for Help\ **Created:** [May 19, 2021, 9:50am UTC](https://community.glideapps.com/t/change-in-the-way-column-date-data-are-handled/26964 "2021-05-19T09:50:34Z")\ **Posts on this page:** 1\ **Showing post:** 2
**Author:** ![Darren\_Murphy](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/darren_murphy/32/47326_2.png) [@Darren\_Murphy](https://community.glideapps.com/u/Darren_Murphy)\ **Post date:** [May 19, 2021, 10:04am UTC](https://community.glideapps.com/t/change-in-the-way-column-date-data-are-handled/26964/2 "2021-05-19T10:04:27Z")
> [@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!](https://community.glideapps.com/t/scripts-scripts-scripts/18965/97): > > 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](https://en.wikipedia.org/wiki/ISO_8601) datetime (except it isn’t face_with_symbols_over_mouth) 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. --- _[View the full topic](https://community.glideapps.com/t/change-in-the-way-column-date-data-are-handled/26964)._