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

Delay Until error

  • 14 January 2020
  • 5 replies
  • 431 views
A
  • Anonymous
  • 0 replies

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?




icon

Best answer by jesse 15 January 2020, 14:30

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

Bryan_from_workload
Userlevel 3
Badge +1

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)


A

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

Thanks for your prompt reply👍️


A

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


Bryan_from_workload
Userlevel 3
Badge +1

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


jesse
Userlevel 7
Badge +9

@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