Create report that calculates 1 and 3 year evaluations...

D

Donna

Hi!

Does anyone have a suggestions of how to create a report that groups on
month, that shows who is due for an evaulation based on hire date (employees
are evaluated 1 year as a summary and 3 year full evalaution)?

I'm currently using the following that works great for the one year but
can't figure out how to calculate 3 year...

DateSerial(Year(Date())-(DateSerial(Year(Date()),Month([FacultyHireDate]),
Day([FacultyHireDate]))<Date()),Month([FacultyHireDate]),
Day([FacultyHireDate]))

Thanks!
Donna
 
Top