# Time difference in Current Date/Time

**URL:** <https://community.glideapps.com/t/time-difference-in-current-date-time/48765>\
**Category:** Ask for Help\
**Created:** [September 7, 2022, 9:28am UTC](https://community.glideapps.com/t/time-difference-in-current-date-time/48765 "2022-09-07T09:28:13Z")\
**Posts on this page:** 8\
**Page:** 1

<div class="post-metadata">

**Author:** ![Nathan\_Brun](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/nathan_brun/32/47424_2.png) [@Nathan\_Brun](https://community.glideapps.com/u/Nathan_Brun)\
**Post date:** [September 7, 2022, 9:28am UTC](https://community.glideapps.com/t/time-difference-in-current-date-time/48765/1 "2022-09-07T09:28:13Z")

</div>

Hello !

I have an action that adds a row in my Airtable database with a column with the actual date and time. I use “Current Date/Time” in the Add Row action in this column.

Since 2 days, the time that is returned is two hours behind the time of the device used and I don’t now why. The hour in the virtual device in glide is correct and changes according to the time of the device, but the time returned by the action is 2 hours behind.

Thank for help !

---

<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:** [September 8, 2022, 1:00am UTC](https://community.glideapps.com/t/time-difference-in-current-date-time/48765/2 "2022-09-08T01:00:20Z")

</div>

May we know what timezone are you in? I assume UTC+2?

The “current date/time” in Glide does respect the current hour of the device, but when they write it to the database, it does not contain the timezone info.

Say you’re 7AM UTC+2, what they seem to actually write to the database is 7AM UTC. Then Airtable converts it to your timezone, so that fits with your description that it’s 2 hours behind.

Glide is experimenting a feature to “respect” the timezone of the device, but it might only be for Glide Tables at first. No ETA for an official launch.

---

<div class="post-metadata">

**Author:** ![Nathan\_Brun](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/nathan_brun/32/47424_2.png) [@Nathan\_Brun](https://community.glideapps.com/u/Nathan_Brun)\
**Post date:** [September 8, 2022, 8:36am UTC](https://community.glideapps.com/t/time-difference-in-current-date-time/48765/3 "2022-09-08T08:36:09Z")

</div>

Thank you for your answer.

The problem is that Airtable does not do this conversion because I store the date and time in a ‘Text’ column to avoid time zone problems. It is therefore Glide that sends the UTC time and not the time of my device.

Here is an example: Pressing this button sends the current time in the “DJ\_Glide” column. This column is in text format to simplify time zone problems. And we can see that Glide sends the UTC time and not the time of my device. (10h32)

 ![glide](https://us1.discourse-cdn.com/flex002/uploads/glideapps/original/3X/5/2/5282736a0d5edc84188c56e5f0374c7233af0fa8.png)

So the problem is not an Airtable conversion but Glide returns the time in UTC format. And this happens only since a few days, before it was returning the time of the device.

---

<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:** [September 8, 2022, 8:38am UTC](https://community.glideapps.com/t/time-difference-in-current-date-time/48765/4 "2022-09-08T08:38:36Z")

</div>

When you double click the cell, does it show the same “9/8/2022, 8:32:32 AM” format or does it show it in a Zulu format?

---

<div class="post-metadata">

**Author:** ![Nathan\_Brun](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/nathan_brun/32/47424_2.png) [@Nathan\_Brun](https://community.glideapps.com/u/Nathan_Brun)\
**Post date:** [September 8, 2022, 9:07am UTC](https://community.glideapps.com/t/time-difference-in-current-date-time/48765/5 "2022-09-08T09:07:42Z")

</div>

When I double click, it shows the same because it’s a text Area  
 ![image](https://us1.discourse-cdn.com/flex002/uploads/glideapps/original/3X/2/1/210a8ded79fae472f6977415e7891ae42bcc7e95.png)

---

<div class="post-metadata">

**Author:** ![Nathan\_Brun](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/nathan_brun/32/47424_2.png) [@Nathan\_Brun](https://community.glideapps.com/u/Nathan_Brun)\
**Post date:** [September 8, 2022, 9:37am UTC](https://community.glideapps.com/t/time-difference-in-current-date-time/48765/6 "2022-09-08T09:37:13Z")

</div>

In my opinion, Glide must have changed the way it returns “Current Date time” and since a few days it is always returned in UTC format, no matter what time the device has.

I hope this will not change again because it requires a different database organization.

---

<div class="post-metadata">

**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 8, 2022, 10:43am UTC](https://community.glideapps.com/t/time-difference-in-current-date-time/48765/7 "2022-09-08T10:43:19Z")

</div>

For what it’s worth, I did a quick test earlier. Created a simple action that did a Set Column Values, setting a text column to the current date/time. The result was a time stamp in my current local time - UTC+8.

So from my perspective at least, the behaviour hasn’t changed.

I won’t try and speculate what the issue might be in your case, as I’m not familiar with the Glide/AirTable integration.

---

<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:** [September 8, 2022, 11:27am UTC](https://community.glideapps.com/t/time-difference-in-current-date-time/48765/8 "2022-09-08T11:27:22Z")

</div>

[https://share.hsforms.com/16jL7NgZYSsW9DinHwTIqZAbvbdc](https://share.hsforms.com/16jL7NgZYSsW9DinHwTIqZAbvbdc)

Please submit a ticket here so the support team can look more into your problem. Thank you.
