My Google Calendar integration is off a day?

Hello Lauren,

Thanks for reaching out. An event landing a day earlier than the submitted end date is almost always caused by a UTC vs. local timezone mismatch in how the date value is passed to Google Calendar.

Could you please confirm whether the start and end dates coming into the Jotform trigger step are correct for this submission? If not, could you please let us know what the correct dates should be?

IjU3NjYwNTZmMDYzNTA0M2Q1MjY4NTUzMjUxMzA1MTZhNTQzODBmMzUi_pc

dates are correct in the jotform submission but google calendar shows through april 24

coud you update my task or tell me how to make sure the timezone is correct?

Thank you for the confirmation.

Please change the timezone in the Google Calendar action step to UTC, save the step, and check if that resolves the issue.

still coming up a day short. i changed all time conversions and the gcal step to utc

We only needed the timezone in the Google Calendar action step changed for testing. We have reverted all the other timezone changes, except for the Google Calendar one.

Please make another test submission and check if the end date is now appearing correctly.

Thank you for sharing the screenshot. Could you please specify the Start and End dates you submitted in the form so we can make further adjustments?

9/28 start and 10/2 end

We have added a Date/Time Formatter to your workflow, which will allow you to add one day to the end date before passing it to Google Calendar. Please test the workflow and see if this resolves the issue.

just submit another and it's still a day short??? something is happening in the gcal step

Could you please share the Jotform where you are making the submission so that we can make a test submission and make the necessary adjustments?

https://www.jotform.com/222644173878061

i will note that i had this set up in zapier and it worked fine :( i prefer you guy! but figured it's a data point.

We have made a test submission with October 1 as the start date and October 8 as the end date. Could you please check the same event in your Google Calendar?

this one worked! so is it all set now?

Please make a test submission from your end as well and let us know. It should work on your end as well.

Just following up one last time regarding this.

Since we haven't received your reply, we'll be closing this support ticket for now.

If you need any further assistance, please send us an email at support@pabbly.com, and we'll be happy to help.