Hello:
I'm hoping this question has an easy answer. I'd like to create an automation rule that increments any date value 14 days or more in the past to 12-months in the future, relative to each specific date value for that field, issue to issue.
So, for example, imagine a filter result finding 3 issues each with varying dates.
Issue 1 1/1/2020
Issue 2 2/14/2020
Issue 3 5/2/2020
The result automation rule would increment the values as follows:
Issue 1 is updated to 1/1/2021
Issue 2 is updated to 2/14/2021
Issue 3 is updated to 5/2/2021
So far I've only used {{now.plusMonths(12)}} coupled with a filter that runs daily, looking only to the current date. The problem, of course, is that if someone were to accidentally code the date value to be something in the past this daily Automation rule would not pick it up because it would already be farther in the past than the filter looks.
Thanks in advance.