# Problem seeing time in a cell

**URL:** <https://community.glideapps.com/t/problem-seeing-time-in-a-cell/64297>\
**Category:** Ask for Help\
**Created:** [July 23, 2023, 5:51pm UTC](https://community.glideapps.com/t/problem-seeing-time-in-a-cell/64297 "2023-07-23T17:51:03Z")\
**Posts on this page:** 8\
**Page:** 1

<div class="post-metadata">

**Author:** ![artoguide](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/artoguide/32/62640_2.png) [@artoguide](https://community.glideapps.com/u/artoguide)\
**Post date:** [July 23, 2023, 5:51pm UTC](https://community.glideapps.com/t/problem-seeing-time-in-a-cell/64297/1 "2023-07-23T17:51:03Z")

</div>

![Capture d'écran 2023-07-23 192304](https://us1.discourse-cdn.com/flex002/uploads/glideapps/original/3X/d/2/d28fa73b708f73e53ddfc9792d6c0b904cf9c38f.png)  
 ![Capture d'écran 2023-07-23 192250](https://us1.discourse-cdn.com/flex002/uploads/glideapps/original/3X/6/3/63c20a575a51f20e30cf7dc3c095f1f053ffd6e2.png)

Hello Guys,

I have problem related to time.  
I have a field in a table with a date.  
A “Make” scenario, triggered by a stripe payment, send the current date and time to this column.  
However, when the event is triggered, the time that appear is current time +2 hours, and when I click on the cell, the correct time appear.

Do you have any idea how I can do to see the time correctly?

Thank you for your help.

---

<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:** [July 23, 2023, 11:06pm UTC](https://community.glideapps.com/t/problem-seeing-time-in-a-cell/64297/2 "2023-07-23T23:06:23Z")

</div>

Do you have “Respect Time Zone” enabled on on the date column?

---

<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:** [July 23, 2023, 11:53pm UTC](https://community.glideapps.com/t/problem-seeing-time-in-a-cell/64297/3 "2023-07-23T23:53:32Z")

</div>

Is this table Google Sheets/Glide Tables or something else?

---

<div class="post-metadata">

**Author:** ![Eric\_Penn](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/eric_penn/32/73888_2.png) [@Eric\_Penn](https://community.glideapps.com/u/Eric_Penn)\
**Post date:** [July 24, 2023, 12:29am UTC](https://community.glideapps.com/t/problem-seeing-time-in-a-cell/64297/4 "2023-07-24T00:29:04Z")

</div>

> [@artoguide](#):
>
> A “Make” scenario, triggered by a stripe payment, send the current date and time to this column.

Maybe try checking the time zone setting of your Make account

---

<div class="post-metadata">

**Author:** ![artoguide](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/artoguide/32/62640_2.png) [@artoguide](https://community.glideapps.com/u/artoguide)\
**Post date:** [July 24, 2023, 9:34am UTC](https://community.glideapps.com/t/problem-seeing-time-in-a-cell/64297/5 "2023-07-24T09:34:36Z")

</div>

Yes it is enabled.

---

<div class="post-metadata">

**Author:** ![artoguide](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/artoguide/32/62640_2.png) [@artoguide](https://community.glideapps.com/u/artoguide)\
**Post date:** [July 24, 2023, 9:35am UTC](https://community.glideapps.com/t/problem-seeing-time-in-a-cell/64297/7 "2023-07-24T09:35:50Z")

</div>

This is a Glide Table and not a google sheet table.

---

<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:** [July 24, 2023, 11:46am UTC](https://community.glideapps.com/t/problem-seeing-time-in-a-cell/64297/8 "2023-07-24T11:46:46Z")

</div>

It may be adjusting the time to your local timezone and assuming that the time in that cell is GMT time. What Make is writing into that cell is not an ISO standard for dates and does not include any indication as to which timezone that date and time originated from.

Because of the way Make is writing dates to that column, I would disable “Respect Time Zone”. Or, you can maybe keep it enabled, but make sure you are always writing GMT time to that column.

---

<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:** [July 25, 2023, 12:08am UTC](https://community.glideapps.com/t/problem-seeing-time-in-a-cell/64297/9 "2023-07-25T00:08:58Z")

</div>

[https://www.make.com/en/help/functions/date---time-functions](https://www.make.com/en/help/functions/date---time-functions)

I would suggest checking the timezone param of the formatDate function and play around with it, in Make.
