Help

Recurring Date each month with change in a year

Topic Labels: Formulas
525 0
cancel
Showing results for 
Search instead for 
Did you mean: 
Emma_Sousa
5 - Automation Enthusiast
5 - Automation Enthusiast

Hi
I have a formula I found in airtable for creating recurring events. This appears to mostly address when the year rolls to a new one - so that it changes automatically.

What I’d like to do is in my table have a due date of an item - called RECURRING DATE. In a new column called Due Date - I want a formula that will automatically advance the date to the next due date once current due date goes by. I then want to use that Due Date in a calendar view.

The formula I found is:

DATETIME_PARSE(DATETIME_FORMAT({Recurring Date},'MM/DD')&"/"&YEAR(NOW()))

I tested this with a December 21 date and it does in fact advance the year to the new year, but not the day. So if the recurring date is 1/5/22 and we are now on 1/27/22, I want my due date column to show 2/5/22. Is there a way I can modify this formula to achieve that?

0 Replies 0