# \[Conference\]Display Event Time by Timezone **URL:** \ **Category:** Ask for Help\ **Created:** [October 5, 2021, 9:20pm UTC](https://community.glideapps.com/t/conference-display-event-time-by-timezone/32701 "2021-10-05T21:20:47Z")\ **Posts on this page:** 1\ **Showing post:** 7
**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:** [October 7, 2021, 1:37am UTC](https://community.glideapps.com/t/conference-display-event-time-by-timezone/32701/7 "2021-10-07T01:37:44Z")
Glad you got it to work! Just some advice, which I’m sure you realized in my app, is that you probably could have avoided any temporary columns in the google sheet itself. If you know your times are always going to be based on EDT, I think you could have simply created a template column in the glide data editor to join the date column and EDT. The template column would be your your date source for the calendar in the app. The glide calendar is incredibly flexible at interpreting text based dates and times in a variety of formats. Maybe you have reasons for doing it the way you did. 😉 Nothing wrong with how you did it, but just something to keep in mind for the future. Here’s another thread for some inspiration. > [@Fun with Dates](https://community.glideapps.com/t/fun-with-dates/21684): > > I just remembered something from a long time ago. I don’t remember if I had posted about it in this forum or in the old spectrum forum. Can’t find the post in either forum right now. Working on these posts re-triggered this memory. What I had discovered back then is how ridiculously forgiving the calendar layout is. It can take dates in a variety of formats and still determine the correct date to show. But the really cool thing I had discovered is that you can feed it certain types of te… --- _[View the full topic](https://community.glideapps.com/t/conference-display-event-time-by-timezone/32701)._