Re: +1 year to date via automations

803 0
Showing results for 
Search instead for 
Did you mean: 
4 - Data Explorer
4 - Data Explorer

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? image

2 Replies 2

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.

4 - Data Explorer
4 - Data Explorer

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