# š System/GMT Time - Solved!
**URL:** https://community.glideapps.com/t/system-gmt-time-solved/27524
**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:** 3
### Author:  [@gvalero](https://community.glideapps.com/u/gvalero)
#### Post date: [June 4, 2021, 10:08pm UTC](https://community.glideapps.com/t/system-gmt-time-solved/27524/41 "2021-06-04T22:08:22Z")
Hola de nuevo
@Simon_Hill no problem, I understand what you meant. What we are looking for (in my case) is a reliable time using an automatic way without firing a manual action in the middle. Also, if we can do it using Glide tools 100% we would make a home run but sometimes we wish and sometimes we fail š
@Jeff_Hager youāre absolutely rightā¦ te odio! š¤£
You remind me my mom, she always paid attention to details and those rare scenarios that make an exception. I had noticed that problem with timezones with -/+ 30 or 45 min thinking in my country (currently Venezuela quit using -4:30 offset and now we use 4:00).
Having said this, my workaround is useful for 93% of cases š¤
Have a nice nightā¦ feliz noche!
---
### Author:  [@Jeff\_Hager](https://community.glideapps.com/u/Jeff_Hager)
#### Post date: [June 4, 2021, 10:15pm UTC](https://community.glideapps.com/t/system-gmt-time-solved/27524/42 "2021-06-04T22:15:26Z")
> [@gvalero](#):
>
> Also, if we can do it using Glide tools 100% we would make a home run but sometimes we wish and sometimes we fail š
Just to clarify, my solution is 100% Glide. 4 columns in a glide table to determine GMT, which could probably be condensed into 2 columns, to determine GMT or any other time zone (GMT+2 or GMT-2) if needed.
---
### Author:  [@ThinhDinh](https://community.glideapps.com/u/ThinhDinh)
#### Post date: [June 5, 2021, 12:31pm UTC](https://community.glideapps.com/t/system-gmt-time-solved/27524/43 "2021-06-05T12:31:56Z")
@Jeff_Hager the medium format of date/time breaks the logic because it is localized and might include some words that are not āunderstoodā by your logic (in my case itās āthĆ”ngā - which means āmonthā).
A short format fixes it.
---
### Author:  [@Jeff\_Hager](https://community.glideapps.com/u/Jeff_Hager)
#### Post date: [June 5, 2021, 12:47pm UTC](https://community.glideapps.com/t/system-gmt-time-solved/27524/44 "2021-06-05T12:47:39Z")
Good to know. Iāll update it shortly. Looks like only the Local time needs to be in the short format?
---
### Author:  [@ThinhDinh](https://community.glideapps.com/u/ThinhDinh)
#### Post date: [June 5, 2021, 1:21pm UTC](https://community.glideapps.com/t/system-gmt-time-solved/27524/45 "2021-06-05T13:21:21Z")
Yes, only the first one.
---
### Author:  [@Simon\_Hill](https://community.glideapps.com/u/Simon_Hill)
#### Post date: [June 5, 2021, 1:51pm UTC](https://community.glideapps.com/t/system-gmt-time-solved/27524/46 "2021-06-05T13:51:05Z")
Gvalero, to confirm:
My solution works 100% of the time so long as the app is active
Your solution works 93% of the time but still works when the app is not being used. š¤·āāļø
---
### Author:  [@Jeff\_Hager](https://community.glideapps.com/u/Jeff_Hager)
#### Post date: [June 5, 2021, 2:12pm UTC](https://community.glideapps.com/t/system-gmt-time-solved/27524/47 "2021-06-05T14:12:56Z")
I think he means 93% in that it covers all timezones except those rare ones that fall on the 1/2 hour or 3/4 hour, which could throw off the result by an hour for part of an hour. But only in those odd timezones.
---
### Author:  [@Jeff\_Hager](https://community.glideapps.com/u/Jeff_Hager)
#### Post date: [June 5, 2021, 2:17pm UTC](https://community.glideapps.com/t/system-gmt-time-solved/27524/48 "2021-06-05T14:17:59Z")
@ThinhDinh Ok, I changed the Local Date Time to the Short Format for the calculation and added a new math column so I could reformat it to the Medium Format for display purposes.
---
### Author:  [@Darren\_Murphy](https://community.glideapps.com/u/Darren_Murphy)
#### Post date: [June 8, 2021, 3:49pm UTC](https://community.glideapps.com/t/system-gmt-time-solved/27524/49 "2021-06-08T15:49:36Z")
@Jeff_Hager I canāt quite put my finger on why, but I just stumbled on this and it reminded me of youā¦
[ ](https://www.youtube.com/watch?v=-5wpm-gesOY)
š¤£ š¤£
---
### Author:  [@Jeff\_Hager](https://community.glideapps.com/u/Jeff_Hager)
#### Post date: [June 8, 2021, 4:08pm UTC](https://community.glideapps.com/t/system-gmt-time-solved/27524/50 "2021-06-08T16:08:51Z")
š¤£ š¤£ Ha! That was great! That is date and time in a nutshell. Seems simple, but gets more complicated the more you think about it. Thankfully I donāt have to deal with anything nearly that complicated at work. We have servers in different time zones, but everything is synced to one time zone.
I wonder what kind of business that guy works at. Sure covers a lot of different users. š
---
### Author:  [@Robert\_Petitto](https://community.glideapps.com/u/Robert_Petitto)
#### Post date: [June 27, 2021, 2:52am UTC](https://community.glideapps.com/t/system-gmt-time-solved/27524/51 "2021-06-27T02:52:50Z")
This just completed the last piece in the puzzle regarding adding Google calendar events for the userās local time. Brilliant!!!
---
### Author:  [@Robert\_Petitto](https://community.glideapps.com/u/Robert_Petitto)
#### Post date: [June 27, 2021, 5:03pm UTC](https://community.glideapps.com/t/system-gmt-time-solved/27524/52 "2021-06-27T17:03:37Z")
@Jeff_Hager Slight issue with the logicāitās sending me to tomorrow. Ideas?
---
### Author:  [@Jeff\_Hager](https://community.glideapps.com/u/Jeff_Hager)
#### Post date: [June 27, 2021, 7:37pm UTC](https://community.glideapps.com/t/system-gmt-time-solved/27524/53 "2021-06-27T19:37:43Z")
Iāll take a look at the logic. I assume the calculated date in the table has that wrong day and thatās whatās being passed to the calendar?
---
### Author:  [@Robert\_Petitto](https://community.glideapps.com/u/Robert_Petitto)
#### Post date: [June 27, 2021, 8:04pm UTC](https://community.glideapps.com/t/system-gmt-time-solved/27524/54 "2021-06-27T20:04:38Z")
Ya. Figured it out. I was using the start/end times to figure out the offset and not ānowā. Works now!
---
### Author:  [@Jeff\_Hager](https://community.glideapps.com/u/Jeff_Hager)
#### Post date: [June 27, 2021, 8:18pm UTC](https://community.glideapps.com/t/system-gmt-time-solved/27524/55 "2021-06-27T20:18:47Z")
Ahh, good. Made me nervous. š
---
### Author:  [@Darren\_Murphy](https://community.glideapps.com/u/Darren_Murphy)
#### Post date: [September 30, 2021, 12:47pm UTC](https://community.glideapps.com/t/system-gmt-time-solved/27524/56 "2021-09-30T12:47:31Z")
@Jeff_Hager - I implemented this method in one of my apps yesterday, and it was working perfectly. But just now I checked and Iām suddenly getting a GMT offset of -712 hours (it should be +8)
Any idea what might have gone wrong?
---
### Author:  [@Jeff\_Hager](https://community.glideapps.com/u/Jeff_Hager)
#### Post date: [September 30, 2021, 1:24pm UTC](https://community.glideapps.com/t/system-gmt-time-solved/27524/57 "2021-09-30T13:24:17Z")
Must be something with crossing over to a different month??? 712 hours is 29.6 days and a lot of the math uses the day number. Iāll have to think about this.
---
### Author:  [@Darren\_Murphy](https://community.glideapps.com/u/Darren_Murphy)
#### Post date: [September 30, 2021, 1:27pm UTC](https://community.glideapps.com/t/system-gmt-time-solved/27524/58 "2021-09-30T13:27:18Z")
mmm, but itās still 30th September here (for another 2.5 hours), so `Day(now)` still returns 30ā¦
---
### Author:  [@Jeff\_Hager](https://community.glideapps.com/u/Jeff_Hager)
#### Post date: [September 30, 2021, 1:40pm UTC](https://community.glideapps.com/t/system-gmt-time-solved/27524/59 "2021-09-30T13:40:19Z")
Your formula looks different from what I have in the first postā¦but nothing is jumping out to me that would cause such a large offset.
If you break it down, what do you get for a value for each part?
What is your hour(gmt), day(gmt), hour(ldt), day(ldt) so I can hand calc it with your formula?
---
### Author:  [@Darren\_Murphy](https://community.glideapps.com/u/Darren_Murphy)
#### Post date: [September 30, 2021, 1:46pm UTC](https://community.glideapps.com/t/system-gmt-time-solved/27524/60 "2021-09-30T13:46:54Z")
Let me make sure Iām using the correct version. I copied the formula from a copy I made some time ago, so it might be out of date.
Butā¦ I just loaded up your [copyable app](https://embarrassed-shoe-5921.glideapp.io/) in my browser, and this is what I get:
> [@Jeff\_Hager](#):
>
> If you break it down, what do you get for a value for each part?
> What is your hour(gmt), day(gmt), hour(ldt), day(ldt) so I can hand calc it with your formula?
- Hour(gmt) =\> 5
- Day(gmt) =\> 1
- Hour(ldt) =\> 21
- Day(ldt) =\> 30
Hour(gmt) and Day(gmt) are both wrong. They should be 30 and 13 respectively. So I guess that suggests that the Glide ātrickā isnāt working the way we expect it to?
[Previous page](https://community.glideapps.com/t/system-gmt-time-solved/27524.md?page=2)
[Next page](https://community.glideapps.com/t/system-gmt-time-solved/27524.md?page=4)