Adding a Year to a Calculated Date After the Date Has Passed

[kjohns]

I have a form that calculates evaluation task due dates based on an employee's hire date.

For example, for something that needs to be done 45 days in advance of the anniversary date (the employee's hire date, but in the current year), I use the expression =DateSerial(Year(Date()),Month([AnniversaryDate]-45),Day([AnniversaryDate]-45)).

What I need to do is have the dates recalculate to the next year's date after completion of the current year's evaluation. I'd be okay with doing this with a button, as I already "reset" the values of all checkboxes after the evaluation with a button. I'm just not sure how to do this.

Just to give an example, let's say an employee was hired on 3/19/1984 With my calculation above, the task shows a due date of 2/3/2008 (because it's currently 2008). Since his anniversary date for 2008 has passed, I'd like to have the dates reset to 2009 values in anticipation of his next anniversary. Could someone offer suggestions for how to do that?

My main reason for worrying about this is for the employees who have evaluations in the early part of the year, as the ones later in the year will reset automatically at the beginning of the year.

Thanks in advance for any advice you may be able to offer!
Kate

 

[KenHigg]

I think you're going to have to store the date that the last task was completed on work it out from there.

 

[missinglinq]

I agree with Ken that this is one of those exceptions to the rule about not storing calculated data.