# Text to date - delay 6 hours, how to solve it? **URL:** \ **Category:** Ask for Help\ **Created:** [April 22, 2023, 2:39pm UTC](https://community.glideapps.com/t/text-to-date-delay-6-hours-how-to-solve-it/60847 "2023-04-22T14:39:50Z")\ **Posts on this page:** 6\ **Page:** 1
**Author:** ![ohad](https://avatars.discourse-cdn.com/v4/letter/o/f04885/32.png) [@ohad](https://community.glideapps.com/u/ohad)\ **Post date:** [April 22, 2023, 2:39pm UTC](https://community.glideapps.com/t/text-to-date-delay-6-hours-how-to-solve-it/60847/1 "2023-04-22T14:39:50Z")
Hi, My local time now is 17:32. Glide text to date is: 11:32 I am having problem with the time, at 00:00 my app does not resets to “new day”, the date that the user sees still shows “yesterday”. around 6:00 to 7:00 in the morning it starts the new day(and shows the current right date). What do I need to write in local and/or Time zone to fix it? My local time zone is GMT+3 (by google), tried adding GMT+3 and it does not work. ALSO tried using the math column by ‘FIX TIME + 6’ but is calculates only the date and not the hours. Adding screen shot: ![Screenshot 2023-04-22 173539](https://us1.discourse-cdn.com/flex002/uploads/glideapps/original/3X/c/6/c6369e506631bd8e70ae5c50e4348fed69c44669.jpeg) Thank you. ---
**Author:** ![Eric\_Penn](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/eric_penn/32/73888_2.png) [@Eric\_Penn](https://community.glideapps.com/u/Eric_Penn)\ **Post date:** [April 22, 2023, 4:16pm UTC](https://community.glideapps.com/t/text-to-date-delay-6-hours-how-to-solve-it/60847/2 "2023-04-22T16:16:56Z")
Well there might be a better solution overall but you could try ‘FIX TIME + 0.25’ 0.25 will add 6 hours to a date time because 1/4 of a day is equal to 6 hours. ---
**Author:** ![ohad](https://avatars.discourse-cdn.com/v4/letter/o/f04885/32.png) [@ohad](https://community.glideapps.com/u/ohad)\ **Post date:** [April 22, 2023, 7:50pm UTC](https://community.glideapps.com/t/text-to-date-delay-6-hours-how-to-solve-it/60847/3 "2023-04-22T19:50:32Z")
Hi, thank you. That’s solve it , now it shows the right time. But, Is it my PC time? Or the local zone time? What happen if I move to different time zone? Or my users? All my users are from the same time zone, I would like that my time and their time and the app time will all be the same. Thank you. ---
**Author:** ![ThinhDinh](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/thinhdinh/32/49_2.png) [@ThinhDinh](https://community.glideapps.com/u/ThinhDinh)\ **Post date:** [April 23, 2023, 12:54am UTC](https://community.glideapps.com/t/text-to-date-delay-6-hours-how-to-solve-it/60847/4 "2023-04-23T00:54:35Z")
Can you show what’s your configuration for the “Date Fix” column, which “date” value are you using for that? ---
**Author:** ![Uzo](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/uzo/32/22639_2.png) [@Uzo](https://community.glideapps.com/u/Uzo)\ **Post date:** [April 23, 2023, 1:11am UTC](https://community.glideapps.com/t/text-to-date-delay-6-hours-how-to-solve-it/60847/5 "2023-04-23T01:11:43Z")
This is a dangerous solution, Eric 😉 Other users from different time zones will not have the right time. ---
**Author:** ![system](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/system/32/53398_2.png) [@system](https://community.glideapps.com/u/system)\ **Post date:** [April 24, 2023, 1:11am UTC](https://community.glideapps.com/t/text-to-date-delay-6-hours-how-to-solve-it/60847/6 "2023-04-24T01:11:54Z")
This topic was automatically closed 24 hours after the last reply. New replies are no longer allowed.