# 🆕 "Respect time zone" support for Date & Time column in Glide Tables & Airtable **URL:** \ **Category:** Community Resources\ **Created:** [September 14, 2022, 12:54am UTC](https://community.glideapps.com/t/respect-time-zone-support-for-date-time-column-in-glide-tables-airtable/49266 "2022-09-14T00:54:09Z")\ **Posts on this page:** 18\ **Page:** 1
**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 14, 2022, 12:54am UTC](https://community.glideapps.com/t/respect-time-zone-support-for-date-time-column-in-glide-tables-airtable/49266/1 "2022-09-14T00:54:09Z")
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. ![Lucas x Thinh Dinh - Designs · Glide 2022-09-14 at 7.49.10 AM](https://us1.discourse-cdn.com/flex002/uploads/glideapps/original/3X/d/8/d88153ede4f450aed060a0d660aa99b27408d36a.png) 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. ---
**Author:** ![Rosewebstudio](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/rosewebstudio/32/12261_2.png) [@Rosewebstudio](https://community.glideapps.com/u/Rosewebstudio)\ **Post date:** [September 14, 2022, 4:47am UTC](https://community.glideapps.com/t/respect-time-zone-support-for-date-time-column-in-glide-tables-airtable/49266/2 "2022-09-14T04:47:30Z")
That’s neat - thanks for sharing ---
**Author:** ![Yasin\_Hassanien](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/yasin_hassanien/32/9042_2.png) [@Yasin\_Hassanien](https://community.glideapps.com/u/Yasin_Hassanien)\ **Post date:** [September 14, 2022, 4:50am UTC](https://community.glideapps.com/t/respect-time-zone-support-for-date-time-column-in-glide-tables-airtable/49266/3 "2022-09-14T04:50:29Z")
If there is a relation between a google sheet and glide table does that going to affect ? And how ? ---
**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 14, 2022, 5:35am UTC](https://community.glideapps.com/t/respect-time-zone-support-for-date-time-column-in-glide-tables-airtable/49266/4 "2022-09-14T05:35:00Z")
My understanding is that this new feature only works for Native Glide Tables. ---
**Author:** ![Simon\_Hill](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/simon_hill/32/94730_2.png) [@Simon\_Hill](https://community.glideapps.com/u/Simon_Hill)\ **Post date:** [September 14, 2022, 9:00am UTC](https://community.glideapps.com/t/respect-time-zone-support-for-date-time-column-in-glide-tables-airtable/49266/5 "2022-09-14T09:00:26Z")
This is excellent news. Much appreciated. I assume it will now be possible to inspect a user’s time and deduce the time-zone too… cool. ---
**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 14, 2022, 9:57am UTC](https://community.glideapps.com/t/respect-time-zone-support-for-date-time-column-in-glide-tables-airtable/49266/6 "2022-09-14T09:57:25Z")
> [@Simon\_Hill](#): > > I assume it will now be possible to inspect a user’s time and deduce the time-zone too Yeah you can have a “UTC+0 column”, I guess, then just deduct the user’s “now” and that UTC column. ---
**Author:** ![sga](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/sga/32/36912_2.png) [@sga](https://community.glideapps.com/u/sga)\ **Post date:** [February 27, 2023, 10:41pm UTC](https://community.glideapps.com/t/respect-time-zone-support-for-date-time-column-in-glide-tables-airtable/49266/7 "2023-02-27T22:41:22Z")
> [@ThinhDinh](#): > > Yeah you can have a “UTC+0 column”, I guess, then just deduct the user’s “now” and that UTC column. Hi @ThinhDinh! This is so helpful. Saw your responses here as well: [Date Time UTC](https://community.glideapps.com/t/date-time-utc/29742). 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.) ---
**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:** [February 28, 2023, 12:51am UTC](https://community.glideapps.com/t/respect-time-zone-support-for-date-time-column-in-glide-tables-airtable/49266/8 "2023-02-28T00:51:07Z")
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) ---
**Author:** ![sga](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/sga/32/36912_2.png) [@sga](https://community.glideapps.com/u/sga)\ **Post date:** [March 1, 2023, 6:28pm UTC](https://community.glideapps.com/t/respect-time-zone-support-for-date-time-column-in-glide-tables-airtable/49266/9 "2023-03-01T18:28:29Z")
Thanks for the response @ThinhDinh! 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. ---
**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:** [March 1, 2023, 11:52pm UTC](https://community.glideapps.com/t/respect-time-zone-support-for-date-time-column-in-glide-tables-airtable/49266/10 "2023-03-01T23:52:26Z")
![image](https://us1.discourse-cdn.com/flex002/uploads/glideapps/original/3X/b/8/b8cbad00019e99ec4749d9e3c12d2429569caf5c.png) Please let me know if this works for you. ---
**Author:** ![sga](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/sga/32/36912_2.png) [@sga](https://community.glideapps.com/u/sga)\ **Post date:** [March 2, 2023, 5:25pm UTC](https://community.glideapps.com/t/respect-time-zone-support-for-date-time-column-in-glide-tables-airtable/49266/11 "2023-03-02T17:25:39Z")
Wow so simple! As always, thank you @ThinhDinh! Yes this is perfect. ---
**Author:** ![Mns\_Glide](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/mns_glide/32/2514_2.png) [@Mns\_Glide](https://community.glideapps.com/u/Mns_Glide)\ **Post date:** [March 2, 2023, 10:07pm UTC](https://community.glideapps.com/t/respect-time-zone-support-for-date-time-column-in-glide-tables-airtable/49266/12 "2023-03-02T22:07:37Z")
Able to share link on how to use the format date. I could not find it in Glide Docs [Glide • Quickstart](https://www.glideapps.com/docs) TQ ---
**Author:** ![Mns\_Glide](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/mns_glide/32/2514_2.png) [@Mns\_Glide](https://community.glideapps.com/u/Mns_Glide)\ **Post date:** [March 2, 2023, 10:32pm UTC](https://community.glideapps.com/t/respect-time-zone-support-for-date-time-column-in-glide-tables-airtable/49266/13 "2023-03-02T22:32:48Z")
found already [luxon - Immutable date wrapper](https://moment.github.io/luxon/#/formatting?id=table-of-tokens) ---
**Author:** ![Mns\_Glide](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/mns_glide/32/2514_2.png) [@Mns\_Glide](https://community.glideapps.com/u/Mns_Glide)\ **Post date:** [March 2, 2023, 11:19pm UTC](https://community.glideapps.com/t/respect-time-zone-support-for-date-time-column-in-glide-tables-airtable/49266/14 "2023-03-02T23:19:32Z")
Am stuck in converting date time to ISO format using Luxon. Anyone able to share how to do it please. TQ ---
**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:** [March 2, 2023, 11:47pm UTC](https://community.glideapps.com/t/respect-time-zone-support-for-date-time-column-in-glide-tables-airtable/49266/15 "2023-03-02T23:47:55Z")
Try this. `yyyy-MM-dd'T'HH:mm:ss'Z'` ![image](https://us1.discourse-cdn.com/flex002/uploads/glideapps/original/3X/6/7/67cdbfd6ae0693e832e940912f5e997d6886e935.png) Or, this if you want the timezone offset instead. `yyyy-MM-dd'T'HH:mm:ssZZ` ![image](https://us1.discourse-cdn.com/flex002/uploads/glideapps/original/3X/6/5/65d0b4b29e62ba456770595b87b94acc04a78a4b.png) ---
**Author:** ![Mns\_Glide](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/mns_glide/32/2514_2.png) [@Mns\_Glide](https://community.glideapps.com/u/Mns_Glide)\ **Post date:** [March 3, 2023, 3:37am UTC](https://community.glideapps.com/t/respect-time-zone-support-for-date-time-column-in-glide-tables-airtable/49266/16 "2023-03-03T03:37:14Z")
the 2nd one with ZZ works well. thanks @Jeff_Hager ---
**Author:** ![Andrew\_Davies](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/andrew_davies/32/41838_2.png) [@Andrew\_Davies](https://community.glideapps.com/u/Andrew_Davies)\ **Post date:** [September 24, 2025, 7:14am UTC](https://community.glideapps.com/t/respect-time-zone-support-for-date-time-column-in-glide-tables-airtable/49266/17 "2025-09-24T07:14:16Z")
Hello all I have a date / time column, set to date only and NOT respecting time zones. I need the date to stay fixed - regardless of a users timezone. ie - someone in Hawaii sees Saturday 12th May, and little me in London sees the same. I don’t include or use time in this field. I keep that separate. I often use lookups to get a date and it returns UTC time for example 2025-09-28T00:00:00.000Z I’ve tried testing by changing my computer’s time zone and it seems to stay fixed (always shows T00:00:000Z) but I’d like to be sure (and not back in Hawaii until February!) Anyone know if I am safe or have any other suggestions? Andrew ---
**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 24, 2025, 7:28am UTC](https://community.glideapps.com/t/respect-time-zone-support-for-date-time-column-in-glide-tables-airtable/49266/18 "2025-09-24T07:28:23Z")
Yes, I believe you should be fine, as long as the value isn’t changed (eg. with a date/time picker or by setting the current date/time). Just to be clear (and I’m sure you already know this), even though you have set the column to Date Only, that’s just for display purposes. The stored value still includes a time, as is evident from your lookup result.