Timezone setting not honored at Zap level

​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.

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. 

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.

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.

​@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/

If the issue persists, then I recommend opening a ticket with Zapier Support: https://zapier.com/app/get-help

Hi there ​@Arment! 👋

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.