May 26, 2021 12:41 PM
I followed this support article almost exactly in an attempt to repeat yearly deadlines (grant applications), but for some reason, everything automatically copies over except for the new date. I used the formula DATEADD(Date, 365, ‘day’) to create a column that adds a year to each date (which does work), then tried to input that as the date when my automation creates a new record (triggered by it entering a “past events” view, containing any event with a date before today, so that when a day passes it gets added to next year’s calendar). But alas, the date just won’t copy over.
Does anyone have any suggestions? Thank you! ❤️
The support article I followed:
May 26, 2021 01:12 PM
JK I FIGURED IT OUT
Just in case anyone else has this problem, idk why, but when I changed my trigger to “when a record matches conditions” and set the conditions to “when the Date is today” instead of going into a view, it solved the problem and automatically copies all the info to next year’s calendar :slightly_smiling_face:
May 26, 2021 01:44 PM
I recommend that you use
DATEADD(Date, 1, 'years'). Some years have more than 365 days. :winking_face:
May 26, 2021 02:28 PM
Lol I was totally putting in ‘year’ instead of ‘years’ and couldn’t get it to work. Will do, thank you!