# Time Zone and "Current Date/Time"?

**URL:** <https://community.glideapps.com/t/time-zone-and-current-date-time/70742>\
**Category:** Ask for Help\
**Created:** [February 12, 2024, 3:14pm UTC](https://community.glideapps.com/t/time-zone-and-current-date-time/70742 "2024-02-12T15:14:00Z")\
**Posts on this page:** 9\
**Page:** 1

<div class="post-metadata">

**Author:** ![Greg\_Siegel](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/greg_siegel/32/40613_2.png) [@Greg\_Siegel](https://community.glideapps.com/u/Greg_Siegel)\
**Post date:** [February 12, 2024, 3:14pm UTC](https://community.glideapps.com/t/time-zone-and-current-date-time/70742/1 "2024-02-12T15:14:00Z")

</div>

I’m seeing auto-generated time stamps in the future from users in New York – I believe that would mean the current time is reflecting time zones versus UTC. Is that possible? I believe that’s a change?

---

<div class="post-metadata">

**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 12, 2024, 3:15pm UTC](https://community.glideapps.com/t/time-zone-and-current-date-time/70742/2 "2024-02-12T15:15:48Z")

</div>

Do you use “Current Date/Time” when you submit a form or reference it in a column?

---

<div class="post-metadata">

**Author:** ![Greg\_Siegel](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/greg_siegel/32/40613_2.png) [@Greg\_Siegel](https://community.glideapps.com/u/Greg_Siegel)\
**Post date:** [February 12, 2024, 3:18pm UTC](https://community.glideapps.com/t/time-zone-and-current-date-time/70742/3 "2024-02-12T15:18:08Z")

</div>

Thanks for the quick reply – yes, current date/time in a form is what I’m using and would expect not to be time adjusted

---

<div class="post-metadata">

**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 12, 2024, 3:21pm UTC](https://community.glideapps.com/t/time-zone-and-current-date-time/70742/4 "2024-02-12T15:21:20Z")

</div>

Do you use a Glide Table for the destination table? I would uncheck “respect time zones” if you don’t need that.

---

<div class="post-metadata">

**Author:** ![Greg\_Siegel](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/greg_siegel/32/40613_2.png) [@Greg\_Siegel](https://community.glideapps.com/u/Greg_Siegel)\
**Post date:** [February 12, 2024, 3:22pm UTC](https://community.glideapps.com/t/time-zone-and-current-date-time/70742/5 "2024-02-12T15:22:45Z")

</div>

I’m using google sheets as the destination. I’m not seeing that option there?

---

<div class="post-metadata">

**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:** [February 12, 2024, 4:20pm UTC](https://community.glideapps.com/t/time-zone-and-current-date-time/70742/6 "2024-02-12T16:20:59Z")

</div>

Current Time is usually based on the user’s device time, which is calculated locally on the device. It’s always been that way. The feature to respect timezones the @ThinhDinh mentioned is only available in glide tables, and what I think it does is store UTC time, but display time relative to the users local timezones.

---

<div class="post-metadata">

**Author:** ![Greg\_Siegel](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/greg_siegel/32/40613_2.png) [@Greg\_Siegel](https://community.glideapps.com/u/Greg_Siegel)\
**Post date:** [February 12, 2024, 4:35pm UTC](https://community.glideapps.com/t/time-zone-and-current-date-time/70742/7 "2024-02-12T16:35:03Z")

</div>

Thanks - but in that case, how do you know the true time stamp of an entry? I don’t see an option to also log device time zone anywhere?

---

<div class="post-metadata">

**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:** [February 12, 2024, 6:04pm UTC](https://community.glideapps.com/t/time-zone-and-current-date-time/70742/8 "2024-02-12T18:04:08Z")

</div>

You can calculate the user’s timezone offset using the Format Date column, fill it with the current date/time, and use one of the following luxon codes to the the offset number.

![image](https://us1.discourse-cdn.com/flex002/uploads/glideapps/original/3X/6/d/6d2ce9036a5be3e9f9249eed326cf173ab245b2b.png)

 ![image](https://us1.discourse-cdn.com/flex002/uploads/glideapps/original/3X/4/4/44dfabc98c1eed75df9d5acd5155c4bf063f1a87.png)

---

<div class="post-metadata">

**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:** [February 12, 2024, 6:06pm UTC](https://community.glideapps.com/t/time-zone-and-current-date-time/70742/9 "2024-02-12T18:06:16Z")

</div>

Keep in mind that quite a lot of processing happens directly on the user’s device before syncing with the Glide servers. For that reason, we don’t necessarily have ease access to UTC or server time.
