When you create a new Date & Time column for Glide Tables or Airtable, now you will get a âRespect time zonesâ checkbox, which is checked by default.
Before, Glide does not respect time zones, meaning that it will treat the world as if there was only one time zone. If you put in 10:00 AM, it shows us 10:00 AM everywhere, but usually thatâs not the case. Now, the value will change dynamically based on the time zone of the device.
Do you happen to know of any other ways to pull in the current UTC+0 time, via an excel or date function? Unfortunately our team is having some trouble implementing scripts (our fault, weâre not as well versed.)
Do you only need the offset between the userâs time and UTC+0, or do you need the name of the timezone as well? (say the difference is 7 and the timezone name is UTC+7)
We are looking for the offset i.e. +7. We have some helper columns set up to do the math⌠but stuck on pulling in the current time in UTC value to compare the userâs local time against.