# šŸ•’ 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:** 4
**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 30, 2021, 1:49pm UTC](https://community.glideapps.com/t/system-gmt-time-solved/27524/61 "2021-09-30T13:49:18Z")
![image](https://us1.discourse-cdn.com/flex002/uploads/glideapps/original/3X/5/3/53b759935393f5fc280a81ab31bc7f13024f78bf.png) Asian reporting in. Seems like something is off somewhere, maybe a date/time column format? ---
**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 30, 2021, 2:31pm UTC](https://community.glideapps.com/t/system-gmt-time-solved/27524/62 "2021-09-30T14:31:07Z")
Am I seeing that right that my app shows October 2nd, but yours returns October 1st for the GMT day number??? @ThinhDinh mentioned in an earlier post that the short date format seems to work better than long because of language differences, so thatā€™s one thing to try. Checking your math, it checks out with the formula you are currently using and the values you are getting, so I think thatā€™s also part of the the problem. The day part of the formula should only ever return -24, 0, or 24 to account for the GMT and LDT crossing different days and if you are before it after gmt time. You have the extra multiply part, which doesnā€™t seem to fit. I modified the original formula a few times, so I would at least make sure you are using the latest iteration. (5-21) + (24_1_-29) = -16 + -696 = -712 However, that doesnā€™t explain why GMT is calculating into the future. Have you tried different date formats for the NOW column, like @ThinhDinh mentioned? How is your template column set up? I assume you are adding ā€˜GMTā€™? Can you try ā€˜GMT+0ā€™ or UTC as the suffix to see what that does. ---
**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:** [September 30, 2021, 2:38pm UTC](https://community.glideapps.com/t/system-gmt-time-solved/27524/63 "2021-09-30T14:38:38Z")
> [@Jeff\_Hager](#): > > However, that doesnā€™t explain why GMT is calculating into the future. Have you tried different date formats for the NOW column, like @ThinhDinh mentioned? yeah, I had noticed his comment about that and tried different formats, all with the same results. I think that issue only comes into play if you are using languages other than English. > [@Jeff\_Hager](#): > > How is your template column set up? I assume you are adding ā€˜GMTā€™? Can you try ā€˜GMT+0ā€™ or UTC as the suffix to see what that does. I had tried GMT and UTC. I just tried GMT+0, same result. Let me check and make sure my formula is right, and Iā€™ll let you know. ---
**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 30, 2021, 2:43pm UTC](https://community.glideapps.com/t/system-gmt-time-solved/27524/64 "2021-09-30T14:43:46Z")
Iā€™d also be curious if different systems are interpreting GMT differently. I wonder if Mac vs windows vs Android vs iOS would show different results. ---
**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:** [September 30, 2021, 2:47pm UTC](https://community.glideapps.com/t/system-gmt-time-solved/27524/65 "2021-09-30T14:47:54Z")
I just switched mine to use the same formula as in the current iteration of your app, and now Iā€™m getting the same result (-40), as expected. ```auto (hour(GMT)-hour(LDT)) + (24 * (ABS(day(GMT)-day(LDT)) / (day(GMT)-day(LDT))) ) + (minute(GMT)-minute(LDT))/60 ``` Iā€™ve tested on my phone (IOS) and my laptop (MacOS) and both give the same result. I donā€™t have anything that isnā€™t apple to test with, Iā€™m afraid šŸ˜› Anyway, it seems that minute/hour/day(GMT) are no longer giving the expected results. I wonder why that would have suddenly changed? Are you still getting the expected results in your part of the world? So itā€™s interpreting the current GMT time as 6am on the 1st October. I donā€™t know if this is a coincidence, but thatā€™s 8 hours ahead of my current time, whereas the true GMT time is 8 hours before my current 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 30, 2021, 3:02pm UTC](https://community.glideapps.com/t/system-gmt-time-solved/27524/66 "2021-09-30T15:02:40Z")
That is so weird. Itā€™s working fine in my timezone, but I flipped my phone to Singapore time and got the same results as you. Iā€™m not sure what Iā€™m missing, unless something changed on Glideā€™s back end to interpret GMT differently, but it doesnā€™t make sense. Iā€™ll have to do some research on this. My time ![Screenshot_20210930-095228](https://us1.discourse-cdn.com/flex002/uploads/glideapps/original/3X/2/b/2bb875131e9201114cc4cfaa8c5addf0184df426.png) Your time ![Screenshot_20210930-225147](https://us1.discourse-cdn.com/flex002/uploads/glideapps/original/3X/a/6/a61777ab540558dc59993244c2b15221077aed97.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:** [September 30, 2021, 3:11pm UTC](https://community.glideapps.com/t/system-gmt-time-solved/27524/67 "2021-09-30T15:11:20Z")
> [@Jeff\_Hager](#): > > Iā€™m not sure what Iā€™m missing, unless something changed on Glideā€™s back end to interpret GMT differently, Yes, I think we should definitely blame Mark or Jason šŸ¤£ Iā€™m curious to see if anything changes once we roll over to the 1st of the monthā€¦ I might have to switch to an experimental code option, but I try to avoid those unless absolutely necessary. ---
**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:** [September 30, 2021, 3:20pm UTC](https://community.glideapps.com/t/system-gmt-time-solved/27524/68 "2021-09-30T15:20:19Z")
I simplified it by using the time in google sheet as the standard time ---
**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:** [September 30, 2021, 3:22pm UTC](https://community.glideapps.com/t/system-gmt-time-solved/27524/69 "2021-09-30T15:22:32Z")
> [@Jeff\_Hager](#): > > Iā€™d also be curious if different systems are interpreting GMT differently. I wonder if Mac vs windows vs Android vs iOS would show different results. I think it may be OS specificā€¦ I just asked my son, who is in Melbourne Australia, to test with his Windows machine and send me a screen shotā€¦ ![Screen Shot 2021-09-30 at 11.20.19 PM](https://us1.discourse-cdn.com/flex002/uploads/glideapps/original/3X/7/3/737177b393635774f0f711b76a4d177d929b77d9.png) Which is correctā€¦ hmm ---
**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:** [September 30, 2021, 3:23pm UTC](https://community.glideapps.com/t/system-gmt-time-solved/27524/70 "2021-09-30T15:23:32Z")
you can change the time zone on your phone ---
**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 30, 2021, 3:25pm UTC](https://community.glideapps.com/t/system-gmt-time-solved/27524/71 "2021-09-30T15:25:32Z")
You know, it would be a lot easier if they did this math for us. šŸ˜‰ Iā€™ll play with this when Iā€™m done working and by my computer. Iā€™m curious about the month thing too. Maybe this is an OS level bug that you just discovered. ---
**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:** [September 30, 2021, 3:28pm UTC](https://community.glideapps.com/t/system-gmt-time-solved/27524/72 "2021-09-30T15:28:20Z")
> [@Jeff\_Hager](#): > > hiį»u nįŗæu hį» lĆ m bĆ i toĆ”n nĆ y cho chĆŗng ta. : nhĆ”y mįŗÆt: I checked and it is -41 while mine is +7 ---
**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:** [September 30, 2021, 3:30pm UTC](https://community.glideapps.com/t/system-gmt-time-solved/27524/73 "2021-09-30T15:30:36Z")
![13123](https://us1.discourse-cdn.com/flex002/uploads/glideapps/original/3X/6/7/67369447eb17d3d5a891cebe2865675ca46501b1.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:** [September 30, 2021, 3:32pm UTC](https://community.glideapps.com/t/system-gmt-time-solved/27524/74 "2021-09-30T15:32:26Z")
Is that MacOS or Windows? (Iā€™m guessing MacOS) ---
**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:** [September 30, 2021, 3:33pm UTC](https://community.glideapps.com/t/system-gmt-time-solved/27524/75 "2021-09-30T15:33:13Z")
When the time is taken from the device, it is a vulnerability to cause manipulation errors. This I fixed by taking the time on google sheet as standard ---
**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:** [September 30, 2021, 3:33pm UTC](https://community.glideapps.com/t/system-gmt-time-solved/27524/76 "2021-09-30T15:33:28Z")
Windows ---
**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 30, 2021, 3:51pm UTC](https://community.glideapps.com/t/system-gmt-time-solved/27524/77 "2021-09-30T15:51:39Z")
Iā€™ll try this later on my personal computer later, but this might be some to play with to see what kind of results it gives in your timezone. > **[TS Playground - An online editor for exploring TypeScript and JavaScript](https://www.typescriptlang.org/play/?)** > > The Playground lets you write TypeScript or JavaScript online in a safe and sharable way. Obviously flip the date to the incorrect dd/mm/yyyy format in your case. šŸ˜‰ ---
**Author:** ![Mark\_Turrell](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/mark_turrell/32/26605_2.png) [@Mark\_Turrell](https://community.glideapps.com/u/Mark_Turrell)\ **Post date:** [September 30, 2021, 3:52pm UTC](https://community.glideapps.com/t/system-gmt-time-solved/27524/78 "2021-09-30T15:52:22Z")
I get it one day in the futureā€¦ā€¦ ---
**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:** [September 30, 2021, 4:02pm UTC](https://community.glideapps.com/t/system-gmt-time-solved/27524/79 "2021-09-30T16:02:26Z")
@Jeff_Hager it just ticked over to the 1st of October here in Singapore, and guess whatā€¦ ![Screen Shot 2021-10-01 at 12.00.52 AM](https://us1.discourse-cdn.com/flex002/uploads/glideapps/original/3X/d/e/dee2cd82af28d8e6d0b15076de0e871b2bebf75a.png) WTF??? šŸ˜± šŸ¤£ šŸ¤£ ---
**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 30, 2021, 4:07pm UTC](https://community.glideapps.com/t/system-gmt-time-solved/27524/80 "2021-09-30T16:07:27Z")
Clearly itā€™s not a problem with my logic, but a problem with typescript itself. I donā€™t make those kinds of mistakes. šŸ˜‰ [Previous page](https://community.glideapps.com/t/system-gmt-time-solved/27524.md?page=3) [Next page](https://community.glideapps.com/t/system-gmt-time-solved/27524.md?page=5)