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

[Malcolm_Lewis]

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?

[ThinhDinh]

What timezone are you in?

[Malcolm_Lewis]

PST - Los Angeles.

[ThinhDinh]

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

[Malcolm_Lewis]

I don’t see that option. Should I?

[ThinhDinh]

Do you see this?

[Malcolm_Lewis]

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.

[Dilon_Perera]

Here’s what I added and works well.

Thank you

[Malcolm_Lewis]

Here’s the video relativetimeissue

[Malcolm_Lewis]

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.

[Dilon_Perera]

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

Thank you