# Change in the way column date data are handled
**URL:** https://community.glideapps.com/t/change-in-the-way-column-date-data-are-handled/26964
**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:** 3
**Page:** 1
### Author:  [@Thibault\_Milan](https://community.glideapps.com/u/Thibault_Milan)
#### Post date: [May 19, 2021, 9:50am UTC](https://community.glideapps.com/t/change-in-the-way-column-date-data-are-handled/26964/1 "2021-05-19T09:50:34Z")
Is there any change in how the column data in a form are handled?
I have a “today” column in my user profile that takes today’s value (as a date) in `YYYY-MM-DD` format.
I use it in a booking form to populate the “Date” column of my booking table, use the user email to automatically register that too, and let them just specify a booking resource.
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 ☹
Sadly, we cannot specify the date format used by a column reference field in a form.
Any idea folks?
---
### Author:  [@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.
---
### Author:  [@Thibault\_Milan](https://community.glideapps.com/u/Thibault_Milan)
#### Post date: [May 19, 2021, 11:33am UTC](https://community.glideapps.com/t/change-in-the-way-column-date-data-are-handled/26964/3 "2021-05-19T11:33:18Z")
I would love to be able to use the glide data editor but it’s too basic, I have some of those beauties/beast:
```auto
=IFERROR(QUERY(Booking!$A$2:$C,"select C where (B='"&$C513&"' and A='"&TO_TEXT(K513)&"')"),"")
```
or
```auto
=IFERROR(IF(ISNA(QUERY(Booking!$A$2:$D,"select D where (B='"&$C513&"' and A='"&TO_TEXT(Config!$C$2)&"')")),FALSE,QUERY(Booking!$A$2:$D,"select D where (B='"&$C513&"' and A='"&TO_TEXT(Config!$C$2)&"')")),FALSE)
```
and some Google App Script for data manipulation (since the action editors isn’t powerful enough yet).
Nice work with your script to fix dates btw 😉