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?