# Date off by 2 hours in Format Date **URL:** \ **Category:** Ask for Help\ **Created:** [September 9, 2024, 10:19am UTC](https://community.glideapps.com/t/date-off-by-2-hours-in-format-date/76240 "2024-09-09T10:19:20Z")\ **Posts on this page:** 15\ **Page:** 1
**Author:** ![MattGlides](https://avatars.discourse-cdn.com/v4/letter/m/53a042/32.png) [@MattGlides](https://community.glideapps.com/u/MattGlides)\ **Post date:** [September 9, 2024, 10:19am UTC](https://community.glideapps.com/t/date-off-by-2-hours-in-format-date/76240/1 "2024-09-09T10:19:20Z")
So in the date/time column which is respecting timezones and on medium, it is showing the time as 9/9/2024, 12:07:10 PM However, when I format the date using the format date column and the formatting “tt” it returns 10:07:20 AM. How do I fix this or just add 2 hours to the time? ---
**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:** [September 9, 2024, 3:19pm UTC](https://community.glideapps.com/t/date-off-by-2-hours-in-format-date/76240/2 "2024-09-09T15:19:51Z")
What do you mean by “format the date using tt”? Do you mean using the Format Date column? ---
**Author:** ![MattGlides](https://avatars.discourse-cdn.com/v4/letter/m/53a042/32.png) [@MattGlides](https://community.glideapps.com/u/MattGlides)\ **Post date:** [September 9, 2024, 3:30pm UTC](https://community.glideapps.com/t/date-off-by-2-hours-in-format-date/76240/3 "2024-09-09T15:30:53Z")
Correct sorry, format date column and tt is the formatting used. ---
**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:** [September 9, 2024, 11:36pm UTC](https://community.glideapps.com/t/date-off-by-2-hours-in-format-date/76240/4 "2024-09-09T23:36:45Z")
I guess it’s the underlying value that’s at fault here. If you disable respecting timezones, does it still return 10:07:20 AM? ---
**Author:** ![MattGlides](https://avatars.discourse-cdn.com/v4/letter/m/53a042/32.png) [@MattGlides](https://community.glideapps.com/u/MattGlides)\ **Post date:** [September 10, 2024, 1:25pm UTC](https://community.glideapps.com/t/date-off-by-2-hours-in-format-date/76240/5 "2024-09-10T13:25:24Z")
Hi, so it shows it fine in the column itself: ![Screenshot 2024-09-10 152155](https://us1.discourse-cdn.com/flex002/uploads/glideapps/original/3X/d/9/d98b031ae7b1bb69bd9ecc965c062e62ab81229c.png) But when bringing it through with the Single Value and then trying to format it it ends up like so: (3:19 changing to 13:19/1:19) ![Screenshot 2024-09-10 152228](https://us1.discourse-cdn.com/flex002/uploads/glideapps/original/3X/5/6/56049dc9b9683336b1966c00941f00814dfdece7.png) ---
**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:** [September 10, 2024, 2:53pm UTC](https://community.glideapps.com/t/date-off-by-2-hours-in-format-date/76240/6 "2024-09-10T14:53:23Z")
On the original table, if you add a JavaScript column and use “return p1”, with p1 being the datetime column, does it show 13:19 as well? ---
**Author:** ![MattGlides](https://avatars.discourse-cdn.com/v4/letter/m/53a042/32.png) [@MattGlides](https://community.glideapps.com/u/MattGlides)\ **Post date:** [September 10, 2024, 3:21pm UTC](https://community.glideapps.com/t/date-off-by-2-hours-in-format-date/76240/7 "2024-09-10T15:21:19Z")
![Screenshot 2024-09-10 172034](https://us1.discourse-cdn.com/flex002/uploads/glideapps/original/3X/d/f/df89716a75ffee5fa910d92aa547133723e51221.png) Correct, this message was sent at 5:19 and it reflects that in our date column, but when pulling that date it changes to two hours back… ---
**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:** [September 10, 2024, 3:25pm UTC](https://community.glideapps.com/t/date-off-by-2-hours-in-format-date/76240/8 "2024-09-10T15:25:19Z")
If you remove the “respect timezone” checkbox, does it show 3PM or not? ---
**Author:** ![MattGlides](https://avatars.discourse-cdn.com/v4/letter/m/53a042/32.png) [@MattGlides](https://community.glideapps.com/u/MattGlides)\ **Post date:** [September 10, 2024, 3:28pm UTC](https://community.glideapps.com/t/date-off-by-2-hours-in-format-date/76240/9 "2024-09-10T15:28:21Z")
![Screenshot 2024-09-10 172736](https://us1.discourse-cdn.com/flex002/uploads/glideapps/original/3X/c/f/cf97f3578ca8d9f60faadd843c27fc573f75d2e5.png) Whether we have it as respect timezones or not, it shows 5:19 here and 3:19 in the other columns. I have changed it back and forth 4 times. Does not change anything. ---
**Author:** ![MattGlides](https://avatars.discourse-cdn.com/v4/letter/m/53a042/32.png) [@MattGlides](https://community.glideapps.com/u/MattGlides)\ **Post date:** [September 10, 2024, 3:28pm UTC](https://community.glideapps.com/t/date-off-by-2-hours-in-format-date/76240/10 "2024-09-10T15:28:39Z")
Is there no way to just add 2 hours to a date if this isn’t working? ---
**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:** [September 10, 2024, 3:30pm UTC](https://community.glideapps.com/t/date-off-by-2-hours-in-format-date/76240/11 "2024-09-10T15:30:32Z")
Yeah you can just use a math column to do it, e.g: T + 2/24, but it does not solve the original bug. ---
**Author:** ![MattGlides](https://avatars.discourse-cdn.com/v4/letter/m/53a042/32.png) [@MattGlides](https://community.glideapps.com/u/MattGlides)\ **Post date:** [September 10, 2024, 3:32pm UTC](https://community.glideapps.com/t/date-off-by-2-hours-in-format-date/76240/12 "2024-09-10T15:32:25Z")
Should I go report it as a bug and call it there? I can play around a bit more in the meantime. ---
**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:** [September 10, 2024, 3:35pm UTC](https://community.glideapps.com/t/date-off-by-2-hours-in-format-date/76240/13 "2024-09-10T15:35:45Z")
Yeah, I think you should report a bug, though that Format Date column has been known to be troublesome for a long time. ---
**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:** [September 10, 2024, 4:37pm UTC](https://community.glideapps.com/t/date-off-by-2-hours-in-format-date/76240/14 "2024-09-10T16:37:53Z")
The problem with just blindly adding 2 hours is that it may look good to you, assuming you are currently 2 hours away from UTC time, but someone in another timezone is now still off by an hour or more, minus that 2 hours. When ‘Respect Timezone’ is turned on, I believe Glide stores UTC time behind the scenes, and adjusts the time you see to your local timezone. When it’s off, it normally always assumes the the time is local time, regardless of timezone. Like @ThinhDinh said, it feels like a bug and probably a long existing one at that. I don’t feel date handling in Glide has ever been fully polished, especially when using computed date columns. Even ‘Respect Timezone’ seems finicky, but I’ve never had to use it, or deal with it. If you still wanted to work around it, you would have to first figure out the UTC offset for the signed in user first, then take that offset number and add the difference to your date. It’s a doable workaround if needed, but would be better if Glide addressed it properly. ---
**Author:** ![MattGlides](https://avatars.discourse-cdn.com/v4/letter/m/53a042/32.png) [@MattGlides](https://community.glideapps.com/u/MattGlides)\ **Post date:** [September 10, 2024, 4:45pm UTC](https://community.glideapps.com/t/date-off-by-2-hours-in-format-date/76240/15 "2024-09-10T16:45:39Z")
All our customers are based in one country thankfully, including all users etc. I do agree though, still needs to be addressed.