Help

Upcoming database upgrades. to improve our reliability at 03:30 UTC on Feb. 25 / 7:30pm PT on Feb. 24. Some users may briefly experience slow load times or error messages. Learn more here

Auto increasing date column

Topic Labels: Formulas
190 0
cancel
Showing results for 
Search instead for 
Did you mean: 

Hi everyone, I’m a new airtable user who needs some advice how to perform the following task efficiently. I want to track some subscriptions like this:
Screenshot 2021-02-08 at 13.16.18

The renewal date column should auto increase under this circumstances:

If interval monthly:
And {Renewal Date} <= Today()
{Renewal Date} = DATEADD({Renewal Date}, 1, ‘months’)

If interval yearly:
And {Renewal Date} <= Today()
{Renewal Date} = DATEADD({Renewal Date}, 1, ‘year’)

I have already tried several ways, but I am not very satisfied with them. Thank you :slightly_smiling_face:

0 Replies 0