Save the date! Join us on October 16 for our Product Ops launch event. Register here.
May 03, 2024 06:52 AM - edited May 03, 2024 08:25 AM
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!
Solved! Go to Solution.
May 03, 2024 08:44 PM
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
May 03, 2024 08:44 PM
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
May 06, 2024 07:42 AM
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!
Jul 03, 2024 09:30 AM
Hello,
I believe I'm having the exact same issue. Can you share screenshot of your formula field/output?
Thanks!
Jul 04, 2024 06:07 AM
I am using this formula: