# Does the Relative Time column calculation calculate from the actual date/time it's given? **URL:** \ **Category:** Ask for Help\ **Created:** [November 5, 2021, 1:18am UTC](https://community.glideapps.com/t/does-the-relative-time-column-calculation-calculate-from-the-actual-date-time-its-given/34044 "2021-11-05T01:18:51Z")\ **Posts on this page:** 12\ **Page:** 1
**Author:** ![Malcolm\_Lewis](https://avatars.discourse-cdn.com/v4/letter/m/5f9b8f/32.png) [@Malcolm\_Lewis](https://community.glideapps.com/u/Malcolm_Lewis)\ **Post date:** [November 5, 2021, 1:18am UTC](https://community.glideapps.com/t/does-the-relative-time-column-calculation-calculate-from-the-actual-date-time-its-given/34044/1 "2021-11-05T01:18:51Z")
Does the Relative Time column calculation calculate from the actual date/time it’s given? In my app, I have a post that has a PostDate of 11/4/2021, 6:13PM but the relative time column shows 18h. Is it calculating from 11/4/2021, 00:00 AM? ![image](https://us1.discourse-cdn.com/flex002/uploads/glideapps/original/3X/2/e/2e7a155ca74ae9d84cfc122ca7cc9253f68dd26e.png) ![image](https://us1.discourse-cdn.com/flex002/uploads/glideapps/original/3X/e/0/e04b33d1a7e58e84c79d92d9aa5487ca31be5233.png) ![image](https://us1.discourse-cdn.com/flex002/uploads/glideapps/original/3X/9/f/9fec784b90700732ceecc9a65aeaf57bf386e83d.png) ---
**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:** [November 5, 2021, 2:01am UTC](https://community.glideapps.com/t/does-the-relative-time-column-calculation-calculate-from-the-actual-date-time-its-given/34044/2 "2021-11-05T02:01:50Z")
What timezone are you in? ---
**Author:** ![Malcolm\_Lewis](https://avatars.discourse-cdn.com/v4/letter/m/5f9b8f/32.png) [@Malcolm\_Lewis](https://community.glideapps.com/u/Malcolm_Lewis)\ **Post date:** [November 5, 2021, 2:02am UTC](https://community.glideapps.com/t/does-the-relative-time-column-calculation-calculate-from-the-actual-date-time-its-given/34044/3 "2021-11-05T02:02:47Z")
PST - Los Angeles. ---
**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:** [November 5, 2021, 2:03am UTC](https://community.glideapps.com/t/does-the-relative-time-column-calculation-calculate-from-the-actual-date-time-its-given/34044/4 "2021-11-05T02:03:25Z")
What happens if you specify the “now” field with the “current date/time” value? ---
**Author:** ![Malcolm\_Lewis](https://avatars.discourse-cdn.com/v4/letter/m/5f9b8f/32.png) [@Malcolm\_Lewis](https://community.glideapps.com/u/Malcolm_Lewis)\ **Post date:** [November 5, 2021, 2:06am UTC](https://community.glideapps.com/t/does-the-relative-time-column-calculation-calculate-from-the-actual-date-time-its-given/34044/5 "2021-11-05T02:06:24Z")
I don’t see that option. Should I? ![image](https://us1.discourse-cdn.com/flex002/uploads/glideapps/original/3X/0/e/0e44980bfbe524a8f655c22d335600ce7106a4ed.png) ---
**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:** [November 5, 2021, 2:21am UTC](https://community.glideapps.com/t/does-the-relative-time-column-calculation-calculate-from-the-actual-date-time-its-given/34044/6 "2021-11-05T02:21:30Z")
![image](https://us1.discourse-cdn.com/flex002/uploads/glideapps/original/3X/6/1/612cffb4e0c1193ce696646f23ab6adf12b3eced.png) Do you see this? ---
**Author:** ![Malcolm\_Lewis](https://avatars.discourse-cdn.com/v4/letter/m/5f9b8f/32.png) [@Malcolm\_Lewis](https://community.glideapps.com/u/Malcolm_Lewis)\ **Post date:** [November 5, 2021, 2:22am UTC](https://community.glideapps.com/t/does-the-relative-time-column-calculation-calculate-from-the-actual-date-time-its-given/34044/7 "2021-11-05T02:22:48Z")
Yes. I’ve tried that. I see the relative time change for a couple of seconds then it resets to the 00:00 version. Let me see if I can share a video. ---
**Author:** ![Dilon\_Perera](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/dilon_perera/32/85652_2.png) [@Dilon\_Perera](https://community.glideapps.com/u/Dilon_Perera)\ **Post date:** [November 5, 2021, 2:25am UTC](https://community.glideapps.com/t/does-the-relative-time-column-calculation-calculate-from-the-actual-date-time-its-given/34044/8 "2021-11-05T02:25:29Z")
Here’s what I added and works well. ![image](https://us1.discourse-cdn.com/flex002/uploads/glideapps/original/3X/e/b/eb6fc17b3018679a2cbc82000f2443be52345868.png) ![image](https://us1.discourse-cdn.com/flex002/uploads/glideapps/original/3X/d/1/d12d6bbb070eb4d8be1ee304f251add778593a66.png) Thank you ---
**Author:** ![Malcolm\_Lewis](https://avatars.discourse-cdn.com/v4/letter/m/5f9b8f/32.png) [@Malcolm\_Lewis](https://community.glideapps.com/u/Malcolm_Lewis)\ **Post date:** [November 5, 2021, 2:29am UTC](https://community.glideapps.com/t/does-the-relative-time-column-calculation-calculate-from-the-actual-date-time-its-given/34044/9 "2021-11-05T02:29:01Z")
Here’s the video [relativetimeissue](https://streamable.com/s5iuq1) ---
**Author:** ![Malcolm\_Lewis](https://avatars.discourse-cdn.com/v4/letter/m/5f9b8f/32.png) [@Malcolm\_Lewis](https://community.glideapps.com/u/Malcolm_Lewis)\ **Post date:** [November 5, 2021, 3:39am UTC](https://community.glideapps.com/t/does-the-relative-time-column-calculation-calculate-from-the-actual-date-time-its-given/34044/10 "2021-11-05T03:39:21Z")
Solved by @Dilon_Perera — very much appreciated! My Glide table was set to Date/Time, but the underlying Google Sheet column was formatted for date only. ---
**Author:** ![Dilon\_Perera](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/dilon_perera/32/85652_2.png) [@Dilon\_Perera](https://community.glideapps.com/u/Dilon_Perera)\ **Post date:** [November 5, 2021, 3:39am UTC](https://community.glideapps.com/t/does-the-relative-time-column-calculation-calculate-from-the-actual-date-time-its-given/34044/11 "2021-11-05T03:39:25Z")
Ok so I’m using Glide Tables and if you are using Google sheet format the Time and see. Thank you ---
**Author:** ![system](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/system/32/53398_2.png) [@system](https://community.glideapps.com/u/system)\ **Post date:** [November 6, 2021, 3:40am UTC](https://community.glideapps.com/t/does-the-relative-time-column-calculation-calculate-from-the-actual-date-time-its-given/34044/12 "2021-11-06T03:40:15Z")
This topic was automatically closed 24 hours after the last reply. New replies are no longer allowed.