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.

I have set a delay for a zap form a date in a google sheet -14 days... I am getting an error for when this date falls before todays date. (3 days before today)... in this caser I would then want it to just run. 

I get this error

Error Message: "Dates cannot be more than a month in the future"

I have set - How should we handle dates in the past? (optional) to Always continue, which i thought would just make this run but I get an error

Any ideas

Capture.PNG?




Hi there @nh3076 and welcome to the Zapier community!

It looks like you should add a "Formatter" => Date/Time step in between your Google sheet and your delay.

Based on your screenshot, it looks like Zapier is reading your date in American style (mm-dd-yyyy) and your Google Sheet is in "rest of the world" style (dd-mm-yyyy). So the Zap delay thinks you are trying for a date like November 1st, 2020.

Zapier doesn't like to handle delays that far in advance for various reasons.

Hope that helps and please reach back out here if you need more assistance!

Cheers,

Bryan from Workload (Zapier Certified Experts)


Yes you are correct - I figure thats why some dates work and some do not

Thanks for your prompt reply👍️


Ok so now why does this happen? It doesnt seem to be re-formatting it into american format rather reading it as the 2nd of march

Capture.PNGCapture2.PNGEDIT - I changed the form format to custom DD.MM.YYYY - this seems to have done the trick


Hey! I'm glad you were able to solve the issue. Let me know if you need any further help with this, or any other Zaps.


Thanks!

Bryan from Workload - Zapier Certified Experts


@nh3076 Glad you found the solution here! Yes, when dates aren't being formatted as you had hoped, filling out the "From Format" is a helpful trick to help get things back on track again. :)


Terms & Conditions