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! 

Hopefully you can help me.. for a client in the Netherlands, I've built a Zap to add/update a Mailchimp subscriber based on a Google Form. There is an extra field added to Mailchimp: Start date (date her online course starts). The hard date I added to the Zap in this case is the 4th of January 2021. The date I see in Mailchimp and that returns in my test is the 3rd of January 2021?! 

I tried using different formats, even used the formatter after the trigger, but nothing seems to work. I'm almost sure it has something to do with the timezone. I set the timezone of Zapier to Amsterdam and the timezone in Mailchimp is the same. 

Does anyone here have the solution or maybe some other ideas I can try? 

Thanks,

Agnes

Hey @agnesveltboei,

I would have also tried the steps you described. Did you try what arrives when you for example send it to a google sheet or slack instead of Mailchimp? Just to try where this error comes from.

 

Let me know! :)

Hey @Ennes,

Thanks for your quick reply! I'm not sure how to follow your suggestion.

In the Google Form, no date is added. I added a custom field (Start Date) in Mailchimp with the date format (dd/mm/yyyy) and UTC +1 Amsterdam. In Zapier, every time a Google Form is filled and therefore sent to Mailchimp to add/update a subscriber, I also fill this field. But I added this date manually for this specific Zap. 

 

How can I send it to Google Sheet? It would be a different field, right? Because it would be in the automation part of the field filling of Google Sheet. 

 

This is the field in Zapier (that corresponds to STARTDATE in MC), which I filled now with 01-04-2021 (4th of Jan)

 

The test returns this (this is new..):

 

But in Mailchimp:

 

It makes no sense to me anymore :D 

Fixed the issue by adding time and UTC. 

@agnesveltboei Oh nice! Happy for you :)

Terms & Conditions