Google calendar adds 1h to time

[aegis]

Hi all,

I have a database with date/time entries…
I use an action to automatically create a google calendar event with the data.
It was working perfectly fine until today… An entry 17:15 in my database got shifted to 18:15 in google calendar… I don´t understand… Nothing changed…

[Marc_Dillon]

Timezone change?

[Sonrise_Fence_C]

I am having this same Issue, I cant seem to figure out the problem with the timezone. all the events are being created from the wrong timezone.

[Marc_Dillon]

Instead of using NOW(), try using UTCNOW() and adding or subtracting the appropriate hours for your timezone.

[Sonrise_Fence_C]

the problem is that the datetime is not being calculated, I’m selecting the datetime to start the event

[Marc_Dillon]

Oh. Then its not the same problem as the OP. Try putting NOW() into an initial value in your app somewhere, and create a record through the app and see what gets output. This will tell you what the system thinks your timezone is.

[Sonrise_Fence_C]

Ok, Let me give you more details because I noticed 2 things.

1. when i save the event in the app, the time is correct. then a few seconds later it changes the time to an hour later.
2. when i look at the event details in the calendar the event is scheduled with a LA, CA timezone.

how can I change the timezone for just this app? some of my other apps are in California so…

[Marc_Dillon]

Timezones are not set per app. It is all based on what is set as the timezone on the user’s device. So you can have users in multiple timezones.

[Sonrise_Fence_C]

my computer timezone is correct and so is my phone

[Sonrise_Fence_C]

I just realized it works between now and sunday, but monday next week it adds an hour. this is a bug

[Marc_Dillon · Accepted solution]

If you believe it is a bug, please contact support@appsheet.com

[NinaDCS]

I think I’m experiencing something similar. The calendar in the app is changing to an hour later after I sync. Fortunately not affecting my google calendar or ical, they are staying at the correct time, just happening in the app. I’ll contact support.

[louaybaalbaki]

facing the same problem, just sent an email to the support; waiting for their respond; Did they resolve the issue?

[Fabian_Weller]

@aegis @louaybaalbaki @NinaDCS @Sonrise_Fence_C @Marc_Dillon 
Did you ever found a solution or got an answer from supprt?
I found one workaround from @Suvrutt_Gurjar 
"it seems to be happening due to the way Google calendar handles time and daylight savings"
https://www.googlecloudcommunity.com/gc/AppSheet-Q-A/Timezone-bug/m-p/363805/highlight/true#M133013