I'd like to display the current year for a calculated field in a nested IIF function for employee evaluation milestones. We have seasonal and permanent employees. For seasonals, we calculate progress reports at 30-day, 60-day, 90-day due from supervisors for the employees first year of service. For both seasonal and permanent employees, we calculate 120-day, 6 month and 12 months for the first year. Finally, for all employees with more than one year of service we calucate evaluations due once each year on the work anniversary.
I can write nested IIFs in a query based on the employees work anniversary for all the desired milestones, but not for the 12-month anniversary. I'm getting the year 12 months from their anniversary (eg. 2/22/2005, returns 2/22/2006), and I need the current year. I prefer not to display only the mm/dd and adding a text string isn't working well. How can I get a returned value for the current year please?
Thank you very much for any advice?