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!
Page 1 / 1
Hi
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!
The Formatter step worked for me when I tested.
Thanks for the reply
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:
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.
Enter your E-mail address. We'll send you an e-mail with instructions to reset your password.