Users in different time zones

[saucy]

Let me preface by apologising if this has been covered elsewhere - I’ve read lots of topics but remain confused!
I am using Google Sheets on my app for most pages. There is no respect timezones page on my date column because it is Google Sheets, I get that.

What I want to know is does the date/time visible on a user’s app reflect their time zone?

So let’s say on my app it says an event listed is at 2pm UK time.
Would a user in California see this as an event listed as taking place at 6am on their time?

[Darren_Murphy]

@saucy

So let’s say on my app it says an event listed is at 2pm UK time.
Would a user in California see this as an event listed as taking place at 6am on their time?

No, they wouldn’t. Everybody would see the same time no matter where in the world they are.

If you want to convert to each users timezone then what you can do is first determine the users UTC offset, and then apply a correction. And the most reliable method for determining a users UTC offset that I am aware of is the one given in the below thread:

System/GMT Time - Solved!

This is an extension of the request for System Time, please. There’s been a lot of questions for a while about how to get a universal time that can be shared for multiple users across multiple time zones. Most of you will know that any time your get a date/time from one of the glide special values, it will always be the user’s local time. But if you don’t know which time zone they are in, then you have no easy way to convert that date/time into something standard, like Greenwich Mean Time, to…

[saucy]

Thanks Darren!

So to clarify, if someone from California added something to the app scheduled for 2pm their time that would also appear as 2pm my time right?

[Darren_Murphy]

Yes, that’s correct.