Date Time Format Glide calculated column - Time zone is not correct

Report a Bug
1

Hi Glide Team,
The time zone of the Date Time Format column is not showing the correct Time.
Please help.

2

That very first column in your table - “Date”
What happens if you edit that column, make no changes, and save it again?

3

Just tried it, still the same
just looks different

image
image1013Ă—793 85.6 KB

4

Okay, never mind. Was just a hunch.

Anyway, it looks like the Format Date column is adjusting for your local time zone, which I assume is UTC+3?

The format of the data in the first column is ISO-8166, and the Z on the end indicates that it’s UTC. So the Format Date column is probably doing the right thing in this case. There might be an option that can be used to “fix” that - I haven’t looked closely enough at the docs yet to say for sure.

1 Like
5

This column is written only using an action “current date time” from within the app.
It does not come from the sheet and it is not edited anywhere else.
So how can glide write in one time zone but then display in another?

1 Like
6

I don’t know exactly how it works, but I would assume that under the hood Glide would store all dates/times as UTC, and then convert to local time for display based on the user device/browser settings.

Anyway, I’ve been having my own (separate) issues with the Format Date plugin today, so I’m not ready to fully trust it just yet. It might be a good idea to stick to your original solution just for now.

Or somebody else might have an idea.

7

Yes you are right.
I don’t trust it either, but I cant use YC so I’m stuck until this is solved :expressionless:

8

Why can’t you use the YC column?

9

ohhhhh my bad… I missed it among all the new computed columns and thought it was disabled for new columns.
ok problem solved for now

1 Like
10

I think what they do is store everything in UTC (with the Z at the end) as you said, but that created some problems when my users are not in the same timezone, and they try to create something like an event.

Had to add a column to get their timezone, then convert things with some columns to make sure users always get their localized time.

1 Like
11

Closing due to inactivity. This topic will be deleted in a few weeks if there are no more comments.