Every January 30th I need to add 1 year to a date, how can I do this?
I've created a date field that has the starting date, i.e. 01/30/2023 and another field which is equal today. I then have another calculated field that adds a year to the starting date once Today > Starting Date. The problem is how do I deal with it the following year. I'd rather not rely on a workflow copying the calculated field to another field for use the next year but maybe that's the only way. Why does Dynamics make it so hard to work with dates?!