# Data written to spreadsheet from app as Text format not Time format **URL:** \ **Category:** Ask for Help\ **Created:** [October 25, 2021, 3:20am UTC](https://community.glideapps.com/t/data-written-to-spreadsheet-from-app-as-text-format-not-time-format/33555 "2021-10-25T03:20:02Z")\ **Posts on this page:** 1\ **Showing post:** 16
**Author:** ![Jeff\_Hager](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/jeff_hager/32/43_2.png) [@Jeff\_Hager](https://community.glideapps.com/u/Jeff_Hager)\ **Post date:** [January 6, 2023, 8:38pm UTC](https://community.glideapps.com/t/data-written-to-spreadsheet-from-app-as-text-format-not-time-format/33555/16 "2023-01-06T20:38:12Z")
Ah, got it. It is a date type column, but the grid makes it appears as a text column. Not sure if that’s a bug, or because one of the dates is actually a text string. I guess in my case, I don’t do anything special in the google sheet. The data coming in from Glide is fine with me as long as glide is interpreting it correctly on it’s end. So in my case, even if a date came in as text, it’s fine as long as glide still treats it as a date. I would be more curious to know what you do in the google sheet that requires it to be recognized as a date instead of text. Maybe there is some logic that can be moved to glide instead. As for the date column, it is ridiculously flexible at interpreting dates. You can type something arbitrary, such as ‘3 days from now’ and it will convert it to a date. That text is obviously a text string, but glide is able to interpret a date from that. Manually typing a date is just typing text, so it’s sent to the google sheet as text. More on the in the thread below. > [@Fun with Dates](https://community.glideapps.com/t/fun-with-dates/21684): > > I just remembered something from a long time ago. I don’t remember if I had posted about it in this forum or in the old spectrum forum. Can’t find the post in either forum right now. Working on these posts re-triggered this memory. What I had discovered back then is how ridiculously forgiving the calendar layout is. It can take dates in a variety of formats and still determine the correct date to show. But the really cool thing I had discovered is that you can feed it certain types of te… If you can explain the main problem you are having, I may have a solution. You mentioned something about sorting. Is the data not sorting correctly if a user manually enters a date through the grid? I haven’t done much yet with the grid, especially with dates and allowing users to edit dates, so I’m learning too. --- _[View the full topic](https://community.glideapps.com/t/data-written-to-spreadsheet-from-app-as-text-format-not-time-format/33555)._