+1 year to date via automations

[Adam_Yo]

Hi there, I have a database of social media campaigns with start dates and end dates. I’d like to have both dates add a year when the end date is older than yesterday (so once the campaign ends, it’s automatically set up to happen next year).

Ideally, I’d like it to happen once per month, but it can be any trigger. I should add that I’m on the free tier of Airtable

I’ve tried a few things, but I can’t seem to get the formula DATEADD({Start Date}, 1, 'years') to work with the automation. Any suggestions?

[kuovonne]

Adam_Yo:

I can’t seem to get the formula DATEADD({Start Date}, 1, 'years') to work with the automation.

Where are you putting the formula? You cannot use formulas directly in the automation itself. You need to put the formula in a formula field. Then the automation can read the value from the formula field and move the value to a different editable field.

[DavidMillanP]

Thank you Kuvonne! I did it!! woop woop!!