GCalendar Daylight Savings Time Issue

BMAP
Participant I

My Problem is obviously with Daylight Savings Time which ends in the US at 11/01/2020 2:00 am (reverts to 1:00am) For any date/time that I set for after 11/1/2020 2am, GCalendar subtracts an hour.

Example:

I create an event item for 10/31/2020 at 2:30am; It properly adds/syncs to GCalendar as 10/31//2020 @ 2:30am

If I edit the above (or create a new event) for 11/01/2020 at 2:30am ; it syncs to GCalendar as 11/01/2020 @ 1:30am.

Thoughts?

0 4 310
4 REPLIES 4

BMAP
Participant I

Bump. Iโ€™m still stuck with this.

My Event table has separate [Time] and [Date] fields, which automatically creates a separate [DateTime] Field by formula.

A trigger ADDS A NEW ROW to the Google Calendar Table using the calculated [Date Time] as [Start]
Google [End] field is [Date Time] + [Duration]

The AppSheet Logs show the correct [Start] and [End] data being added

โ€œ11/20/2020 11:00:00โ€,
โ€œ11/20/2020 12:00:00โ€,

But on Google Calendar it subtracts 1 hour (11/2020 10:00:00)

Again it does not do this IF the date/time is before 11/1/2020 2:00a.m.

Any Ideas?

Please contact support@appsheet.com for help with this.

@BMAP 
Did you ever found a solution or got an answer from supprt?
I found one workaround from @Suvrutt_Gurjar 
https://www.googlecloudcommunity.com/gc/AppSheet-Q-A/Timezone-bug/m-p/363805/highlight/true#M133013

ScottE
Participant II

@Fabian_Weller The @BMAP  account was mine under a different GApp login that I no longer have.  I seem to recall a PM from an admin indicating there was a bug, but I had already come to some resolution.  

My recollection is a bit fuzzy, except to note that I no longer use Appsheet's built in Calendar database.  I created a separate calendar table and use external App Scripts to create/modify/delete Google Calendar entries via API.

Sorry I don't have more info.

Top Labels in this Space