# Text to Date problem
**URL:** https://community.glideapps.com/t/text-to-date-problem/55894
**Category:** Ask for Help
**Created:** [December 19, 2022, 8:33pm UTC](https://community.glideapps.com/t/text-to-date-problem/55894 "2022-12-19T20:33:21Z")
**Posts on this page:** 14
**Page:** 1
### Author:  [@Alexander\_Rubino](https://community.glideapps.com/u/Alexander_Rubino)
#### Post date: [December 19, 2022, 8:33pm UTC](https://community.glideapps.com/t/text-to-date-problem/55894/1 "2022-12-19T20:33:21Z")
What am I doing wrong?
It is obviously not the correct date
---
### Author:  [@Jeff\_Hager](https://community.glideapps.com/u/Jeff_Hager)
#### Post date: [December 19, 2022, 8:48pm UTC](https://community.glideapps.com/t/text-to-date-problem/55894/2 "2022-12-19T20:48:26Z")
When you expand the Birthday Date column, what is showing as the time?
---
### Author:  [@Alexander\_Rubino](https://community.glideapps.com/u/Alexander_Rubino)
#### Post date: [December 19, 2022, 8:49pm UTC](https://community.glideapps.com/t/text-to-date-problem/55894/3 "2022-12-19T20:49:42Z")
---
### Author:  [@Jeff\_Hager](https://community.glideapps.com/u/Jeff_Hager)
#### Post date: [December 19, 2022, 9:04pm UTC](https://community.glideapps.com/t/text-to-date-problem/55894/4 "2022-12-19T21:04:29Z")
If you go to [https://time.is](https://time.is), does the time correspond with your local time? Is there any warning on the page about your clock being wrong? Seems that something is causing the time to back up by 2 hours. I can’t reproduce it, but I wonder if your browser or OS has the wrong time or timezones set. I’m assuming you are in the GMT+1 zone?
---
### Author:  [@slscustom.ru](https://community.glideapps.com/u/slscustom.ru)
#### Post date: [December 19, 2022, 9:12pm UTC](https://community.glideapps.com/t/text-to-date-problem/55894/5 "2022-12-19T21:12:47Z")
text is 1 12 2014
This is a common - all Glide’s time plugins return wrong date time
---
### Author:  [@Alexander\_Rubino](https://community.glideapps.com/u/Alexander_Rubino)
#### Post date: [December 19, 2022, 9:15pm UTC](https://community.glideapps.com/t/text-to-date-problem/55894/6 "2022-12-19T21:15:20Z")
The date seems to be correct. When I use glides Text to Date link, it works as well. Only inside of glide it doesn’t work
> **[Glide • Text to Date column](https://www.glideapps.com/plugins/parse-date)**
>
> Convert text to a date.
---
### Author:  [@Uzo](https://community.glideapps.com/u/Uzo)
#### Post date: [December 19, 2022, 9:19pm UTC](https://community.glideapps.com/t/text-to-date-problem/55894/7 "2022-12-19T21:19:49Z")
the problem is with indicating a time zone, and which one is a month and which is a day… so don’t rely on this… unless the text has month as a name and is including Z zone… script has no way to know how to decode that date, it will show the first returning response… and sometimes is not what you are looking for…
01/11/12… January 11/2012?.. or November 1 /1012 or December 11/3001… 😉
---
### Author:  [@Jeff\_Hager](https://community.glideapps.com/u/Jeff_Hager)
#### Post date: [December 19, 2022, 9:38pm UTC](https://community.glideapps.com/t/text-to-date-problem/55894/8 "2022-12-19T21:38:16Z")
What is the timezone that you have set on your computer. I have a suspicion that it doesn’t match what it should be. I can kind of duplicate the issue if I change my timezone to one that does not match my current location.
You could adjust the timezone in the Text to Date column by adding UTC+2 in the timezone column, but that might not be reliable depending on how widespread your app is.
As a workaround, if time is not very important, you could add an hour of 1 to your template and parse that as well. Not great, but something to try.
---
### Author:  [@slscustom.ru](https://community.glideapps.com/u/slscustom.ru)
#### Post date: [December 19, 2022, 9:41pm UTC](https://community.glideapps.com/t/text-to-date-problem/55894/9 "2022-12-19T21:41:35Z")
> [@Jeff\_Hager](#):
>
> UTC+2
no luck
---
### Author:  [@Jeff\_Hager](https://community.glideapps.com/u/Jeff_Hager)
#### Post date: [December 19, 2022, 9:52pm UTC](https://community.glideapps.com/t/text-to-date-problem/55894/10 "2022-12-19T21:52:01Z")
Oddly, I get the correct date, but a time of noon. I would expect midnight. Didn’t catch that right away.
---
### Author:  [@slscustom.ru](https://community.glideapps.com/u/slscustom.ru)
#### Post date: [December 19, 2022, 10:15pm UTC](https://community.glideapps.com/t/text-to-date-problem/55894/11 "2022-12-19T22:15:05Z")
Aug 6, 2014
wrong date, wrong time
---
### Author:  [@Jeff\_Hager](https://community.glideapps.com/u/Jeff_Hager)
#### Post date: [December 20, 2022, 12:02am UTC](https://community.glideapps.com/t/text-to-date-problem/55894/12 "2022-12-20T00:02:01Z")
I’ve been debugging the code for a while and I don’t know why it’s doing this, but if you don’t specify a timezone, it seems to be calculating the timezone and offset based on your local system. It seems wrong to me, but I can’t find a way around it.
I’m wondering if this is a side affect from when Glide added the ‘Respect Time Zones’ feature. Maybe by default, it’s trying to convert to your local timezone when it shouldn’t.
You may need to submit this to glide support.
---
### Author:  [@Uzo](https://community.glideapps.com/u/Uzo)
#### Post date: [December 20, 2022, 12:32am UTC](https://community.glideapps.com/t/text-to-date-problem/55894/13 "2022-12-20T00:32:35Z")
I test it, and it looks like Glide is adjusting GMT offset in the wrong direction… instead of subtracting… is adding… so my solution is to get Navigator GMT offset and substract from Date to Text column:
---
### Author:  [@slscustom.ru](https://community.glideapps.com/u/slscustom.ru)
#### Post date: [December 20, 2022, 9:05am UTC](https://community.glideapps.com/t/text-to-date-problem/55894/14 "2022-12-20T09:05:00Z")
Big thanks for advice, Uzo!
In this moment i no need to immediately solution, because if i will use it in a customer app and then Glide have to change plugin behavior to right way this may affect customer service and meaning.
Also big thanks for Jeff\_Hager!