1vote

Formula for an automation that sets due-date to next year, but fixed day and month

Hi togther,

i´m looking for a formula that sets the due-date for a recurring task to one year in the future, but always a fixed day and month. I understand that the year goes with 'dateAdd(now(), 1, "years")' but i can´t find out how to set a fixed month and day. Chatgpt istn´t a great help here also...

Thanks to you all :)

Cheers Christian

1 Answer

0vote

Imrul Points180

You’re on the right track using dateAdd(now(), 1, "years") to move the due date forward. To set a fixed day and month (e.g. always March 15), regardless of the original date, you can combine the formatDate and dateParse functions like this:

dateParse(formatDate(dateAdd(now(), 1, "years"), "YYYY") + "-03-15")

This takes the current year +1, then formats it into a string like "2025-03-15", and converts it back into a date object. Just replace 03-15 with your desired MM-DD.

If you'd like help automating this for recurring tasks or need a prebuilt Notion template for recurring systems, feel free to reach out!

Please log in or register to answer this question.

...

Welcome to Notion Answers, where you can ask questions and receive answers from other members of the community.

Please share to grow the Notion Community!

Connect