Does the Relative Time column calculation calculate from the actual date/time it's given?

Ask for Help
1

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

image
image746×886 45.6 KB

image
image760×1052 66.4 KB

2

What timezone are you in?

3

PST - Los Angeles.

4

What happens if you specify the “now” field with the “current date/time” value?

5

I don’t see that option. Should I?

image
image736×1272 93.4 KB

6

image
image702×1242 54.7 KB

Do you see this?

7

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.

8

Here’s what I added and works well.

image

image

Thank you

9

Here’s the video relativetimeissue

10

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.

11

Ok so I’m using Glide Tables and if you are using Google sheet format the Time and see.

Thank you