Automated Google Calendar End Date ends a day early

[Mike_Campanella]

I have an automation set up to add an event to my google calendar. It is working fine except, the end date it shows on the calendar is showing up the day before it ends. I have the events with no time listed because i do not want a specific start and end time for them. When i have the all day box checked in the automation It is showing on the calendar as ending a day earlier. When i make the "all day" under configurations in the automation dynamic and pick the end date it gives the start time and end time as 8AM in google calendar.  Is there a solution for this? Thanks in advance for any help!

[TheTimeSavingCo · Accepted solution]

Might be a timezone issue in play here.  Could you try:
1. Showing the timezone in your "End Date" field
2. Find the difference between your timezone and the timezone displayed from step 1
3. Create a formula field and use DATEADD() to create set the correct time you want it to be
4. Use that formula field's output in your automation

[Mike_Campanella]

The Formula field with DATEADD seems to be the solution! I tried the time zone and that didn't make an difference. DATEADD works but its weird because i have to add 2 days to it to make it work correctly. Either way its working now. Thank you for the help!

[mrjkruger]

Hello,

I believe I'm having the exact same issue. Can you share screenshot of your formula field/output?

Thanks!

[Mike_Campanella]

I am using this formula: 

DATEADD({End Date}, 1, 'days')

I'm not sure what I changed since my last response but I only need to add 1 day now and it is working.