# šŸ•’ System/GMT Time - Solved! **URL:** \ **Category:** Project Showcase\ **Created:** [June 2, 2021, 3:27pm UTC](https://community.glideapps.com/t/system-gmt-time-solved/27524 "2021-06-02T15:27:23Z")\ **Posts on this page:** 20\ **Page:** 6
**Author:** ![phong\_tran](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/phong_tran/32/32160_2.png) [@phong\_tran](https://community.glideapps.com/u/phong_tran)\ **Post date:** [October 1, 2021, 10:54am UTC](https://community.glideapps.com/t/system-gmt-time-solved/27524/101 "2021-10-01T10:54:56Z")
![icon-02-1](https://us1.discourse-cdn.com/flex002/uploads/glideapps/original/3X/5/e/5e7165102bcc657254248d7473c85e930545ceb8.png) ---
**Author:** ![phong\_tran](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/phong_tran/32/32160_2.png) [@phong\_tran](https://community.glideapps.com/u/phong_tran)\ **Post date:** [October 1, 2021, 10:56am UTC](https://community.glideapps.com/t/system-gmt-time-solved/27524/102 "2021-10-01T10:56:02Z")
And also on my android phone ![4745a04ae33b2a65732a](https://us1.discourse-cdn.com/flex002/uploads/glideapps/original/3X/d/1/d160af351ab3d57c4e47f2e1aa4df1ad4d608a1a.jpeg) ---
**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:** [October 1, 2021, 11:32am UTC](https://community.glideapps.com/t/system-gmt-time-solved/27524/103 "2021-10-01T11:32:34Z")
@Jeff_Hager I havenā€™t copied back and check, are you using the ā€œmediumā€ format to calculate the dates. I donā€™t know if changing to ā€œshortā€ solves all problems. ---
**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:** [October 1, 2021, 1:21pm UTC](https://community.glideapps.com/t/system-gmt-time-solved/27524/104 "2021-10-01T13:21:18Z")
@ThinhDinh Iā€™m using the short format for the values used in the calculation base on your recommendation. Iā€™m not sure yet how to reproduce this. I started to change the region and time settings on my computer, but it may require a restart. Iā€™ll try to take a look and figure out whatā€™s going on. @phong_tran just to make sure, have you refreshed the app to make sure you have the latest changes? ![image](https://us1.discourse-cdn.com/flex002/uploads/glideapps/original/3X/5/9/590991d219141ff85030a92d566a6b4bb34e6da4.png) ---
**Author:** ![phong\_tran](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/phong_tran/32/32160_2.png) [@phong\_tran](https://community.glideapps.com/u/phong_tran)\ **Post date:** [October 2, 2021, 1:13am UTC](https://community.glideapps.com/t/system-gmt-time-solved/27524/105 "2021-10-02T01:13:29Z")
I just went to the link you sent and now the difference is -17 ---
**Author:** ![John\_Cabrera](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/john_cabrera/32/2066_2.png) [@John\_Cabrera](https://community.glideapps.com/u/John_Cabrera)\ **Post date:** [November 7, 2021, 12:46pm UTC](https://community.glideapps.com/t/system-gmt-time-solved/27524/106 "2021-11-07T12:46:30Z")
As of tonight, this broke. When the clocks changed something happened, and the North American date format no longer works. I have users in Europe who are fine (their format is 7, November, 2021 00:00). I have an app that has relied on this code for 6 months and the app is suddenly useless. @Mark I know you donā€™t officially support this method, but is there any way to give us what we had before the times changed tonight? Having a way to get UTC is critical to the functioning of a community app that allows members to schedule worldwide. Is there any solution here? 400 users basically without an app in an instant. šŸ˜ž ---
**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 7, 2021, 1:32pm UTC](https://community.glideapps.com/t/system-gmt-time-solved/27524/107 "2021-11-07T13:32:52Z")
@John_Cabrera are you using the latest version of the math formula? We uncovered an edge case about a month ago that caused it to fail around the end of each month. Although your issue sounds like itā€™s different (related to a switch to daylight savings time?), itā€™s probably worth checking that you have the correct formula. > [@Jeff\_Hager](#): > > ```auto > (HOUR(gmt)-HOUR(ldt)) > > + > > (24 * ( > ABS((YEAR(gmt)*10000+MONTH(gmt)*100+DAY(gmt)) > -(YEAR(ldt)*10000+MONTH(ldt)*100+DAY(ldt))) > / > ((YEAR(gmt)*10000+MONTH(gmt)*100+DAY(gmt)) > -(YEAR(ldt)*10000+MONTH(ldt)*100+DAY(ldt))) > )) > > + > > (MINUTE(gmt)-MINUTE(ldt))/60 > > ``` Update: Actually, @John_Cabrera I just realised that we do have another option now with the new [Format Date](https://www.glideapps.com/plugins/format-date) plugin. All you need to do is pass that the users time with the `Z` format parameter, and itā€™ll return the users UTC offset. ![Screen Shot 2021-11-07 at 9.54.23 PM](https://us1.discourse-cdn.com/flex002/uploads/glideapps/original/3X/c/7/c7433d5f2d8a483836f7efb0a4c9cbb6baebf7db.png) ---
**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:** [November 7, 2021, 2:54pm UTC](https://community.glideapps.com/t/system-gmt-time-solved/27524/108 "2021-11-07T14:54:56Z")
Yeah, like @Darren_Murphy mentioned, I would give the new plugin a shot over my method. I havenā€™t tested it yet, but hopefully it works better. Out of curiosity though, what exactly broke? I checked may app and my Offset value did update from -5 to -6 like I expected. ---
**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 7, 2021, 3:02pm UTC](https://community.glideapps.com/t/system-gmt-time-solved/27524/109 "2021-11-07T15:02:56Z")
> [@Jeff\_Hager](#): > > Yeah, like @Darren_Murphy mentioned, I would give the new plugin a shot over my method. I havenā€™t tested it yet, but hopefully it works better. I just replaced your method with the plugin method in 4 of my apps, and it seems to work perfectly šŸ™‚ ---
**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 12, 2021, 4:39pm UTC](https://community.glideapps.com/t/system-gmt-time-solved/27524/110 "2021-11-12T16:39:43Z")
@Jeff_Hager looks like I spoke too soon. The Format Date option appears to have stopped working šŸ™„ ![Screen Shot 2021-11-13 at 12.36.55 AM](https://us1.discourse-cdn.com/flex002/uploads/glideapps/original/3X/4/e/4e97ff24ca1f21e5f19cafa8ec026b556f645bab.png) Does it work for you? (Iā€™m willing to bet that it doesā€¦ but not my whole house šŸ˜ƒ ) ---
**Author:** ![SantiagoPerez](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/santiagoperez/32/16807_2.png) [@SantiagoPerez](https://community.glideapps.com/u/SantiagoPerez)\ **Post date:** [November 12, 2021, 4:57pm UTC](https://community.glideapps.com/t/system-gmt-time-solved/27524/111 "2021-11-12T16:57:47Z")
I am not Jeff but it is working for me. @Darren_Murphy ![Screen Shot 2021-11-12 at 10.57.20 AM](https://us1.discourse-cdn.com/flex002/uploads/glideapps/original/3X/c/d/cda2b11547f5fe504fe5e86416a36fbf94ea9131.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 12, 2021, 5:26pm UTC](https://community.glideapps.com/t/system-gmt-time-solved/27524/112 "2021-11-12T17:26:27Z")
Yep, thatā€™s what I expected. Iā€™d also be willing to bet that it probably doesnā€™t work for @ThinhDinh. Or for @V88 either šŸ˜‰ ---
**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 12, 2021, 10:48pm UTC](https://community.glideapps.com/t/system-gmt-time-solved/27524/113 "2021-11-12T22:48:57Z")
Haha I will check later but I have switched to the American formatting awhile ago so didnā€™t notice this when I first tried the columnā€¦ ---
**Author:** ![kyleheney](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/kyleheney/32/41173_2.png) [@kyleheney](https://community.glideapps.com/u/kyleheney)\ **Post date:** [November 12, 2021, 11:03pm UTC](https://community.glideapps.com/t/system-gmt-time-solved/27524/114 "2021-11-12T23:03:30Z")
Hasnā€™t worked for me since we spoke last about it! ---
**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 12, 2021, 11:55pm UTC](https://community.glideapps.com/t/system-gmt-time-solved/27524/115 "2021-11-12T23:55:51Z")
Can confirm, itā€™s not working if I change the browser language to Vietnamese. ---
**Author:** ![V88](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/v88/32/90054_2.png) [@V88](https://community.glideapps.com/u/V88)\ **Post date:** [November 14, 2021, 10:47am UTC](https://community.glideapps.com/t/system-gmt-time-solved/27524/116 "2021-11-14T10:47:21Z")
Iā€™ve pretty much given up on a solution to this. Seems so simple. I just want to convert all user timestamped events into UTC so that I can sort entities like comments (not built in but my own creation) chronologically in apps where my users are globally distributed. How can it be such a pain? ---
**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 14, 2021, 11:03am UTC](https://community.glideapps.com/t/system-gmt-time-solved/27524/117 "2021-11-14T11:03:51Z")
Iā€™m currently using a variation of [this](https://community.glideapps.com/t/yc-for-time-zone-change/34402/13). The only change I made was to negate the return value, as Iā€™m converting _from_ UTC _to_ local time, so I need the local offset rather than the UTC offset. (If you read the [docs for getTimezoneOffset](https://www.w3schools.com/jsref/jsref_gettimezoneoffset.asp), youā€™ll see it returns the difference between UTC and local - so it gives the UTC offset from local time, as opposed to the local offset from UTC time) So Iā€™m using: ```auto return -(new Date().getTimezoneOffset())/60 ``` I think thatā€™s probably going to be the most reliable solution for now. ---
**Author:** ![V88](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/v88/32/90054_2.png) [@V88](https://community.glideapps.com/u/V88)\ **Post date:** [November 15, 2021, 8:21am UTC](https://community.glideapps.com/t/system-gmt-time-solved/27524/118 "2021-11-15T08:21:42Z")
Will take a look for sure - cheers @Darren_Murphy ---
**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:** [November 25, 2021, 4:50pm UTC](https://community.glideapps.com/t/system-gmt-time-solved/27524/119 "2021-11-25T16:50:57Z")
![image](https://us1.discourse-cdn.com/flex002/uploads/glideapps/original/3X/c/4/c4a394e47b441622dada79350359699cdf0cb603.jpeg) ---
**Author:** ![david](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/david/32/62831_2.png) [@david](https://community.glideapps.com/u/david)\ **Post date:** [April 9, 2024, 6:44pm UTC](https://community.glideapps.com/t/system-gmt-time-solved/27524/120 "2024-04-09T18:44:50Z")
[Previous page](https://community.glideapps.com/t/system-gmt-time-solved/27524.md?page=5) [Next page](https://community.glideapps.com/t/system-gmt-time-solved/27524.md?page=7)