In my Zap Details menu, I have timezone set to “GMT+00:00 Atlantic/Reykjavik”. Image shown below as reference. Also, my account is set to Eastern Time (New York GMT-05:00).
On an action in the Zap workflow, I have start time set to 3:30pm GMT-0000, for UTC time. End time doesn’t have timezone defined but is set in an ISO 8601 format.
In the results that follow, I see 10:30am and 7pm.
I’m assuming here that Zapier is taking 3:30pm UTC time, removing 5 hours, and adding it to the application. Same goes for end time as there is a 5 hour difference there.
So that begs the question, what’s the purpose of the Zap timezone setting? Am I not using it correctly? Is there a setting to have Zapier not automatically adjust for time zones?
Page 1 / 1
Hi @Arment
I suspect the issue is with the format of the Event Start Date/Time.
Try using a Formatter > Date & Time > Adjust step to set the desired value to make sure to the format is consistent with the timestamp format used in the Event End Date/Time.
Hi @Troy Tessalone
I did try using the Formatter > Date & Time to make sure I got the desired value out. I added the screenshots below to show the process.
All time from Microsoft is in UTCOutput is -0000 for GMT-00:00I want to insert the date as UTC time and not EST. Should display as 9:30pmStill converts to 4:30pm instead of 9:30pm.
I’ve been working on this for a few days now and it is a bit of a head scratcher. I still don’t know if the timezone setting on the Zap does anything as it still reverts any timestamp formatted to Eastern Time.
@Arment
The From Form is not the same as the Input Format.
You can clear the From Format field selection as that is optional.
What time zone are the timestamps from Zap step 1 returned in?
What are the time zone settings set in the app being used in Zap step 10?
The time zone from step 1 is UTC time, as mentioned in my caption image.
The time zone settings on the App in step 10 is (UTC-06:00) Central Time (US & Canada).
I cleared From Format but I haven’t noticed a difference in the results.
@Arment
If the app in Zap step 10 is configured to use Central Time Zone, then have you tried using the Formatter step to convert the UTC timestamps from Step 1 to Central Time Zone to be used in Zap step 10?
I’ve taken some screenshots of your suggestion. Unless I’m doing it incorrectly, it still displays the result in Eastern Time.
9:30pm UTC to US/CentralOutput result is correct, given that Central Time Zone is 6 hours behind UTC. 3:30pmHow it shows in step 10
End result - 3:30pm Central changed to 4:30pm Eastern. 10pm UTC changed to 5pm Eastern.
And just in case, I changed the end time to be Central Time Zone. It shouldn’t matter if it is hand-typed in, formatting is the same as Start Date/Time.
As you can see, the 3:30pm and 4:45pm Central Time turned into 4:30pm and 5:45pm Eastern Time. Ignore the Event Time Zone as it is a separate field not influenced by the time entered in.
I can confirm with 100% certainty the time adjustment to Eastern Time is done at the Zapier level.
@Arment
Have you tried removing the trailing time zone offset that is part of the timestamps? (e.g. -0600)
That way you are providing the exact time value you expect and matches the timezone of the app used in the Zap step.
Yep! Already did that. Screenshots below for results.
Both Start Time and End Time are in UTC, but the trailing time zone offset is removed.Result - 9:30 UTC converts to Eastern. 10:00 UTC converts to 5pm Eastern.
@Arment
Have you tried turning the Zap ON and testing live?
Then check the Zap Runs history details to see the DATA IN/OUT for each step to help you troubleshoot: https://zapier.com/app/history/
How are things going on this? Were you able to get this solved?
If not, I wonder if the times being 1 hour out previously might be to do with daylight savings time—do you think that could be the case?
Looking forward to hearing from you!
Hi @SamB!
Still an issue unfortunately, but I did find my own workaround.
The times are more than an hour out due to the shift in multiple time zones. In this particular case, I want to set the Zap’s timezone to UTC or GMT+00:00, as shown in the first image. However, when the time gets entered into the iMIS application, it shows as Eastern Time (EST) which is the setting I have on my Zapier account. The timezone set on the iMIS application system is set to Central Time, 1 hour behind Eastern.
Is the timezone setting shown in the first image supposed to calculate the time entered into the application? I haven’t received any clarification on that and documentation on Zap details is hard to find. What I was able to find, is the documentation for datetime fields and how they are influenced by my account’s timezone settings.
The Learn more page does suggest specifying timezone, which can be seen in my previous posts.
Sorry, I meant to say UTC’s Z-0000 converts over to Eastern at the time it writes to the application. Is there a way to keep the time as UTC?
If I assume everything is in Eastern Time, then I can make my own calculations from there for the other timezones coming from Microsoft. It’s just unfortunate I couldn’t use UTC as my base.
Hi @Arment,
Thank you so much for sharing your workaround with this issue. This will significantly help our Community members with the same issue.
