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 folks, trying to use formatter to get a specific date in the next twelve months.  So lets say I meet with a client every January 15th - how do I get the formatter to give me an output that’s “the next January 15” from today?  I tried doing input “next January 15” but it keeps giving me a date in 01-15-2025 instead of 01-15-2024 (the next one at the time of this post).  Appreciate the help!

Hi @ChrisDiodato 

Good question.

Try using Date/Time Modifiers.

 

 

Hi @tessalone !  Sorry for the late reply on this and thanks for sending me this information.  This seems like a really good solution for trying to format dates to add specific amounts of time to the current date if it can be measured in days, months, years, etc.  but what I’m trying to do is just get Zapier to find the next January. 

In other words, If I have an input of 9/22/2023 or 3/2/2023, I want Zapier to give me the next January first (01/01/2024).  Think this is possible?  Thanks!

 

@Troy Tessalone 

@ChrisDiodato 

The Formatter step worked for me when I tested.

 

 

 

Thanks for the reply @Troy Tessalone and for bearing with me with all of this.  Right, so formatter with add/subtract gets you a specific date in relation to today’s date -- I’m looking for something different.

 

I’m trying to get January 15th of the following year regardless of what the input date is.  I’m trying to do this so I can use the date to set up tasks in my Wealthbox for new clients which occurs every January.

So ideally I have a client fill out a google form on 6/1/2024 (the input).  I’d like to create a function that gives me 1/15/2025 (January 15th of the following year).  Or another example, they fill out the form on 12/10/2023 -- I’d like the function to give me January 15th of the following year (1/15/2024).  Does this make sense?  Again, really appreciate your help!

This thread seemed like it was on the right track but it was specific to day of the week:

 

@ChrisDiodato 

Why not simplify it to this…

Change the To Format to be a custom value of YYYY, which will return just the year.

Then in the desired fields you can set a hybrid value like this: sYYYY]-01-15

Where rYYYY] is the variable for the year returned from the Formatter step.

 

Terms & Conditions