# Date Time Format Glide calculated column - Time zone is not correct **URL:** \ **Category:** Report a Bug\ **Created:** [November 9, 2021, 12:29pm UTC](https://community.glideapps.com/t/date-time-format-glide-calculated-column-time-zone-is-not-correct/34249 "2021-11-09T12:29:47Z")\ **Posts on this page:** 14\ **Page:** 1
**Author:** ![Lin\_Altshuler](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/lin_altshuler/32/32591_2.png) [@Lin\_Altshuler](https://community.glideapps.com/u/Lin_Altshuler)\ **Post date:** [November 9, 2021, 12:29pm UTC](https://community.glideapps.com/t/date-time-format-glide-calculated-column-time-zone-is-not-correct/34249/1 "2021-11-09T12:29:47Z")
Hi Glide Team, The time zone of the Date Time Format column is not showing the correct Time. Please help. ---
**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:** [November 9, 2021, 12:36pm UTC](https://community.glideapps.com/t/date-time-format-glide-calculated-column-time-zone-is-not-correct/34249/2 "2021-11-09T12:36:17Z")
That very first column in your table - “Date” What happens if you edit that column, make no changes, and save it again? ---
**Author:** ![Lin\_Altshuler](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/lin_altshuler/32/32591_2.png) [@Lin\_Altshuler](https://community.glideapps.com/u/Lin_Altshuler)\ **Post date:** [November 9, 2021, 12:37pm UTC](https://community.glideapps.com/t/date-time-format-glide-calculated-column-time-zone-is-not-correct/34249/3 "2021-11-09T12:37:28Z")
Just tried it, still the same just looks different ![image](https://us1.discourse-cdn.com/flex002/uploads/glideapps/original/3X/9/2/9298511737b8f73fa2864271c678ee5a3503a415.png) ---
**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:** [November 9, 2021, 12:42pm UTC](https://community.glideapps.com/t/date-time-format-glide-calculated-column-time-zone-is-not-correct/34249/4 "2021-11-09T12:42:49Z")
Okay, never mind. Was just a hunch. Anyway, it looks like the Format Date column is adjusting for your local time zone, which I assume is UTC+3? The format of the data in the first column is ISO-8166, and the Z on the end indicates that it’s UTC. So the Format Date column is probably doing the right thing in this case. There might be an option that can be used to “fix” that - I haven’t looked closely enough at the docs yet to say for sure. ---
**Author:** ![Lin\_Altshuler](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/lin_altshuler/32/32591_2.png) [@Lin\_Altshuler](https://community.glideapps.com/u/Lin_Altshuler)\ **Post date:** [November 9, 2021, 12:45pm UTC](https://community.glideapps.com/t/date-time-format-glide-calculated-column-time-zone-is-not-correct/34249/5 "2021-11-09T12:45:06Z")
This column is written only using an action “current date time” from within the app. It does not come from the sheet and it is not edited anywhere else. So how can glide write in one time zone but then display in another? ---
**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:** [November 9, 2021, 12:52pm UTC](https://community.glideapps.com/t/date-time-format-glide-calculated-column-time-zone-is-not-correct/34249/6 "2021-11-09T12:52:50Z")
I don’t know exactly how it works, but I would assume that under the hood Glide would store all dates/times as UTC, and then convert to local time for display based on the user device/browser settings. Anyway, I’ve been having my own (separate) issues with the Format Date plugin today, so I’m not ready to fully trust it just yet. It might be a good idea to stick to your original solution just for now. Or somebody else might have an idea. ---
**Author:** ![Lin\_Altshuler](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/lin_altshuler/32/32591_2.png) [@Lin\_Altshuler](https://community.glideapps.com/u/Lin_Altshuler)\ **Post date:** [November 9, 2021, 12:55pm UTC](https://community.glideapps.com/t/date-time-format-glide-calculated-column-time-zone-is-not-correct/34249/7 "2021-11-09T12:55:10Z")
Yes you are right. I don’t trust it either, but I cant use YC so I’m stuck until this is solved 😑 ---
**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:** [November 9, 2021, 12:58pm UTC](https://community.glideapps.com/t/date-time-format-glide-calculated-column-time-zone-is-not-correct/34249/8 "2021-11-09T12:58:10Z")
Why can’t you use the YC column? ---
**Author:** ![Lin\_Altshuler](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/lin_altshuler/32/32591_2.png) [@Lin\_Altshuler](https://community.glideapps.com/u/Lin_Altshuler)\ **Post date:** [November 9, 2021, 1:00pm UTC](https://community.glideapps.com/t/date-time-format-glide-calculated-column-time-zone-is-not-correct/34249/9 "2021-11-09T13:00:13Z")
ohhhhh my bad… I missed it among all the new computed columns and thought it was disabled for new columns. ok problem solved for now ---
**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:** [November 9, 2021, 1:35pm UTC](https://community.glideapps.com/t/date-time-format-glide-calculated-column-time-zone-is-not-correct/34249/10 "2021-11-09T13:35:14Z")
I think what they do is store everything in UTC (with the Z at the end) as you said, but that created some problems when my users are not in the same timezone, and they try to create something like an event. Had to add a column to get their timezone, then convert things with some columns to make sure users always get their localized 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:** [December 9, 2021, 10:28pm UTC](https://community.glideapps.com/t/date-time-format-glide-calculated-column-time-zone-is-not-correct/34249/11 "2021-12-09T22:28:10Z")
Closing due to inactivity. This topic will be deleted in a few weeks if there are no more comments. ---
**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:** [December 9, 2021, 10:28pm UTC](https://community.glideapps.com/t/date-time-format-glide-calculated-column-time-zone-is-not-correct/34249/12 "2021-12-09T22:28:11Z")
---
**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:** [January 8, 2022, 10:29pm UTC](https://community.glideapps.com/t/date-time-format-glide-calculated-column-time-zone-is-not-correct/34249/13 "2022-01-08T22:29:25Z")
---
**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:** [January 8, 2022, 10:29pm UTC](https://community.glideapps.com/t/date-time-format-glide-calculated-column-time-zone-is-not-correct/34249/14 "2022-01-08T22:29:25Z")