Skip to main content

Get Support
Have a question? Let's get you an answer!

How Do I...? Troubleshooting Code & Webhooks Developer Zone

Other Help Resources
Wait, there's more! Check out these Community sourced spaces for additional resources.

Zapier Help Center Hire an Expert

Learning Resources
All of our best learning resources can be found here.

Featured Articles Show & Tell Zapier's products AI Hub Zapier Tools Hub

Share your knowledge
Give back to the Community by sharing your automation wins and helping to answer questions.

Share your success See unanswered questions User Groups

Other Learning Resources
Some of our favorite additional ways to upskill your Zapier knowledge.

Zapier Learn Zapier Blog Zapier Webinars

Product Updates
Check out what is new and upcoming with Zapier with our regular product updates.

Product Updates

Early Access Program
Want to join Early Access? Learn more here.

Hi there,

I have a zap that is fires up every day at 00:00 and writes a record into a table. When the record is created, it also adds zap_meta_human_now: MM/DD/YY hh:mmAM/PM into a column named todaysdate. 

I am on GMT timezone as per defaults.

When I tested this it ran fine and it was able to push the right information into the field, but when it ran on its own this morning, it added yesterday's date into the column:
 

createdTime:
2023-03-30T00:00:45.000Z
fields:
id:
19
todaysdate:
2023-03-29
dayofyear:
88
lastmod:
2023-03-30T00:00:45.000Z

 

This affects the dayofyear field because it uses a formula to grab todaysdate and conclude what day of the year it is.

 


What can I do to resolve this?

Hey @cyberion1985, welcome to the Community!

What timezone are you using in Airtable? Since the UK has recently moved forward an hour and it ran at 00:00:45 I’m wondering whether there’s a mismatch between the timezones and so it took an hour off it which pushed it back into the previous day.

Can you take a look in Airtable and confirm whether the timezone settings there match the timezone settings within the Zap and your profile settings? And update them to match if they’re different.

Also, to confirm whether an hour was indeed removed, can you try changing the settings for that todaysdate field in Airtable temporarily so you can see what time it received, not just the date. 

Eager to get to the bottom of this so please let us know what you find!

Hello @SamB 
 

Thank you, and thanks for getting back to me so soon.

I had a similar thought and now pushed the Zap to start its business at 08:00 instead.
I also updated my timezone because I am running something else that runs on GMT+2, and I want everything to be timely aligned.

Thanks again, and we’ll surely know tomorrow morning at around 8:00 if everything worked out well! Everything points to a timezone issue, so changing these items will surely be enough.

You are most welcome, @cyberion1985! 🤗

Hopefully the changes you’ve made will have sorted it. Please do keep us updated on how it goes, very keen to know whether that solves it! 

Hello @SamB 

The system ran this morning, and the dayofyear was retrieved successfully. The only issue is now that I changed my time-zone to my actual time-zone, the system was scheduled to run at midnight (seems I didn’t save my draft), but it ran at 02:00.

What I will do is I will simply change the timezone back to default and then have the zap run at 08:00 and save it this time.

Hi @cyberion1985 

Yes, that’s correct.

Please keep us posted if errors will occur.

Terms & Conditions