# Timezone Incorrectly converted by GLIDEAPP (conversion is doing the opposite of what it is supposed to do)

**URL:** https://community.glideapps.com/t/timezone-incorrectly-converted-by-glideapp-conversion-is-doing-the-opposite-of-what-it-is-supposed-to-do/8865
**Category:** Report a Bug
**Created:** [May 10, 2020, 4:19pm UTC](https://community.glideapps.com/t/timezone-incorrectly-converted-by-glideapp-conversion-is-doing-the-opposite-of-what-it-is-supposed-to-do/8865 "2020-05-10T16:19:03Z")
**Posts on this page:** 1
**Page:** 1

<div class="post-metadata">

### Author: ![Manuel\_Rodriguez\_do](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/manuel_rodriguez_do/32/16448_2.png) [@Manuel\_Rodriguez\_do](https://community.glideapps.com/u/Manuel_Rodriguez_do)
#### Post date: [May 10, 2020, 4:19pm UTC](https://community.glideapps.com/t/timezone-incorrectly-converted-by-glideapp-conversion-is-doing-the-opposite-of-what-it-is-supposed-to-do/8865/1 "2020-05-10T16:19:03Z")

</div>

My app’s URL: [https://yfhnb.glideapp.io](https://yfhnb.glideapp.io)

I am struggling with timezones in calendar view and seems that there is a **bug in the timezone conversion** from the google sheets date time to user specific settings.

It seems that the conversion is wrongly done in a symmetrical way (i.e. GMT-3 is instead converted to GMT+3 or GMT-1 is instead converted to GMT+1)

To demonstrate this I created 3 events in GMT timezone, being my computer and the google sheets settings also in GMT) and gave the name of the event the GMT time of the event to ease up comparison.

 ![Screenshot 2020-05-10 at 17.08.29](https://us1.discourse-cdn.com/flex002/uploads/glideapps/original/2X/c/c21b6bf0e8f95f315337f9eb7b74c2092a7e533e.jpeg)  
 ![Screenshot 2020-05-10 at 11.53.43](https://us1.discourse-cdn.com/flex002/uploads/glideapps/original/2X/e/ea346b9f9e7675bb9d32afc6086aa7b91ca91a1c.png)

TEST 1:  
**I then changed the timezone from my computer from GMT to EST (GMT-5).**  
(When I do this, the times in glideapps dashboard and google sheets remain the same)  
The time in the app now is converted to GMT+5 instead of GMT-5.

 ![Screenshot 2020-05-10 at 16.08.12](https://us1.discourse-cdn.com/flex002/uploads/glideapps/original/2X/3/3a5cbbe50416049b2e1159594175bd831834cb21.png)

TEST 2:  
**My timezone is changed to GULF STANDARD TIME (GMT+3)**  
The time in the app now is converted to GMT-3 instead of GMT+3.

 ![Screenshot 2020-05-10 at 20.07.41](https://us1.discourse-cdn.com/flex002/uploads/glideapps/original/2X/2/263e881829f65deba2ee98baec6468fa6932c2f1.png)

@Mark @david @Jason
