About Zapier Community
New to our Community? Get to know more about our space and how to make the most of your time here.

Code of Conduct Community FAQ's Zapier Common Questions What to Expect

Get Started With Zapier
New to Zapier? We have got you covered with our Zapier 101 Resources.

Zapier Essentials

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

Zapier Products
Learn more about Zapier's new products.

Zapier Tables Zapier Interfaces

Zapier Reading
All of our best learning resources can be found here.

Featured Articles Show & Tell AI Hub Zapier Tools Hub

Learning Groups
Excited to meet other builders? Check out our interest areas full of doers, dreamers, and in-betweeners.

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.

Best answer

Wrong Date sent into New Record Column

  • 30 March 2023
  • 5 replies
  • 55 views
cyberion1985
Userlevel 1

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?

icon

Best answer by SamB 30 March 2023, 10:48

View original
This post has been closed for comments. Please create a new post if you need help or have a question about this topic.

5 replies

SamB
Rank
Userlevel 7
Badge +11

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!

cyberion1985
Userlevel 1

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.

SamB
Rank
Userlevel 7
Badge +11

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! 

cyberion1985
Userlevel 1

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.

Brem
Userlevel 4
Badge +6

Hi @cyberion1985 

Yes, that’s correct.

Please keep us posted if errors will occur.

Terms & Conditions