# Yet another Timezone question **URL:** \ **Category:** Ask for Help\ **Created:** [December 1, 2022, 2:23am UTC](https://community.glideapps.com/t/yet-another-timezone-question/55277 "2022-12-01T02:23:17Z")\ **Posts on this page:** 10\ **Page:** 1
**Author:** ![Even4749](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/even4749/32/48231_2.png) [@Even4749](https://community.glideapps.com/u/Even4749)\ **Post date:** [December 1, 2022, 2:23am UTC](https://community.glideapps.com/t/yet-another-timezone-question/55277/1 "2022-12-01T02:23:17Z")
Browsing around here, and I’m not seeing an easy workaround, apologies if this has been addressed. We have a live film festival app, with people traveling from multiple timezones to join our event in IST — before they arrive, I’d like them to be able to see the lineup of films as they will be shown here in IST, and not in their phone’s locale. Presently, users in the US are seeing things scheduled to start in the middle of the night. I understand why this happens, but I’m wondering if there’s a workaround (other than my current warning that times will display in their local zone, which is pretty clunky). ---
**Author:** ![Uzo](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/uzo/32/22639_2.png) [@Uzo](https://community.glideapps.com/u/Uzo)\ **Post date:** [December 1, 2022, 2:51am UTC](https://community.glideapps.com/t/yet-another-timezone-question/55277/2 "2022-12-01T02:51:10Z")
you can convert time and show your users two time zones like in my app: > **[Schedule Paid Appointment](https://schedule-appointment.glideapp.io/)** > > Schedule paid appointments, for Google Meet, get calendar reminders, block booked dates and time slots, auto adjust duration to the booked time slots, custom stripe checkout so one for the event location time, and one for user time ---
**Author:** ![Jeff\_Hager](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/jeff_hager/32/43_2.png) [@Jeff\_Hager](https://community.glideapps.com/u/Jeff_Hager)\ **Post date:** [December 1, 2022, 3:08am UTC](https://community.glideapps.com/t/yet-another-timezone-question/55277/3 "2022-12-01T03:08:58Z")
What are you using for a data source? Glide tables, for example, will allow date columns to respect time zones, so it will automatically adjust based on the user’s locale. If you are using a different data source, such as google sheets, then I have a different, but slightly more complicated solution. ![image](https://us1.discourse-cdn.com/flex002/uploads/glideapps/original/3X/2/6/267f790a903f3f3d857ff5816cfefdcf110d135f.png) ---
**Author:** ![Even4749](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/even4749/32/48231_2.png) [@Even4749](https://community.glideapps.com/u/Even4749)\ **Post date:** [December 1, 2022, 3:16am UTC](https://community.glideapps.com/t/yet-another-timezone-question/55277/4 "2022-12-01T03:16:15Z")
Using Airtable. Just to be clear, I do _not_ want to respect user timezones — our event is live only, times are fixed here, and I’d like for people traveling to be able to plan their weekend in advance. ---
**Author:** ![Jeff\_Hager](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/jeff_hager/32/43_2.png) [@Jeff\_Hager](https://community.glideapps.com/u/Jeff_Hager)\ **Post date:** [December 1, 2022, 3:22am UTC](https://community.glideapps.com/t/yet-another-timezone-question/55277/5 "2022-12-01T03:22:03Z")
That’s how it works though. The date and time in your time zone will be converted to the correct date and time in my timezone. Let’s say you create an event for 9:00am and I’m in a timezone 2 hours later than you. For me the time of the event will display as 11:00am. Unless I’m misunderstanding your question, it seems that yes, you do in fact want to respect timezones to show the correct time of the live event in relation to the user’s local timezone. Since I don’t use airtable, can you tell me if you have that checkbox in your date column? ---
**Author:** ![Darren\_Murphy](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/darren_murphy/32/47326_2.png) [@Darren\_Murphy](https://community.glideapps.com/u/Darren_Murphy)\ **Post date:** [December 1, 2022, 3:27am UTC](https://community.glideapps.com/t/yet-another-timezone-question/55277/6 "2022-12-01T03:27:20Z")
> [@Jeff\_Hager](#): > > Unless I’m misunderstanding your question, I think you are 🙂 The way I read it he wants everyone to see the same time, no matter which timezone they are in. I’m thinking a simple solution would be to use your UTC offset algorithm, and then apply a correction based on that to _force_ all users to the same TZ. 🤔 ---
**Author:** ![Jeff\_Hager](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/jeff_hager/32/43_2.png) [@Jeff\_Hager](https://community.glideapps.com/u/Jeff_Hager)\ **Post date:** [December 1, 2022, 3:33am UTC](https://community.glideapps.com/t/yet-another-timezone-question/55277/7 "2022-12-01T03:33:43Z")
Ok, re-read the original post, and I think I understand now. Could it be the case that the checkbox is actually checked when it shouldn’t be? Still not sure if it’s available with airtable though. If it is, then I think unchecking it would work??? I think the checkbox is a replacement to my UTC offset formula, unless you are using google sheets. ---
**Author:** ![Uzo](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/uzo/32/22639_2.png) [@Uzo](https://community.glideapps.com/u/Uzo)\ **Post date:** [December 1, 2022, 3:34am UTC](https://community.glideapps.com/t/yet-another-timezone-question/55277/8 "2022-12-01T03:34:35Z")
just do the offset, and show the event local time / user time… so there is no confusion… but @Jeff_Hager is right… make sure what kind of time is coming from Air table ---
**Author:** ![Even4749](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/even4749/32/48231_2.png) [@Even4749](https://community.glideapps.com/u/Even4749)\ **Post date:** [December 1, 2022, 4:29am UTC](https://community.glideapps.com/t/yet-another-timezone-question/55277/9 "2022-12-01T04:29:00Z")
Thanks, y’all. Yes, @Darren_Murphy has it right. I’ve got people previewing the program before they fly to Laos, and they’re like, “why will you have movies screening at 2:00 a.m.?” Strangely, if I set Airtable to GMT but plug in values for our timezone, when I un-check “respect time zones” in the Glide import of the table, everything appears to be correct. I’m not sure why that works. ---
**Author:** ![Jeff\_Hager](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/jeff_hager/32/43_2.png) [@Jeff\_Hager](https://community.glideapps.com/u/Jeff_Hager)\ **Post date:** [December 1, 2022, 4:46am UTC](https://community.glideapps.com/t/yet-another-timezone-question/55277/10 "2022-12-01T04:46:33Z")
When you uncheck “Respect Time Zones”, then the time is taken literally and timezones are ignored. Even though the time is saved as Zulu or GMT time, Glide will ignore it. If you added a datetime to the table and you had the checkbox checked, then I think glide will save the time as GMT after converting from a user’s local time. Then convert it back to each user’s respective timezones. Good to know that you have the optional checkbox with Air table.