Action adding record to google calendar - result adds 1hr to calendar time

[gpadmin]

I have an action adding an event row to google calendar from booking including startdatetime and enddatetime. It works until it get's to March then entries add 1 hr to the calendar record. I read something about the daylight savings issue in google calendar? how do I fix this in the app? I'm in california timezone. I'm at a standstill until this is resolved. 

Please advise.

Thank you

[AleksiAlkio]

This happens when you add an event from outside of the daylight savings dates and the target date is inside of it. The same happens with the opposite situation (Inside > Outside). Add an additional daylight savings table to your app so you can read correct dates and times year by year.

[gpadmin]

I actually did set up a "global settings" table with the start and end dates for the current year but this will require annual update which could be problematic. I'd rather create a "dynamic" expression but I'm still learning and have searched. Based on our time zone , the starting date is the 2nd Sunday in March and the ending date is the 1st Sunday in November. Can I get assistance on the expression?

[AleksiAlkio]

I assume the date is different in each year. So you would need to have one global settings record for each year.