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?
Hello, 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.
Alex Lewis
@Reply 8 months ago
DateAdd: https://599cd.com/DateAdd
IIF for Future Dates: https://599cd.com/blog/display-article.asp?ID=1352
Hi Anna, thanks for elaborating on your scenario and for sharing the details of your current workaround - plus thanks to the Alexes (Alex's, Alexs'?) for the helpful links and suggestions already provided. It sounds like you need a way to pull in just the current year as part of your calculated field - if you're still running into issues after reviewing those resources, let us know what formula or expression you're currently trying?
It works for a monthly report for supervisors, for both seasonal and permanent employees across our union affliation rules and evaluation milestones. Phew!
Sorry, only students may add comments.
Click here for more
information on how you can set up an account.
If you are a Visitor, go ahead and post your reply as a
new comment, and we'll move it here for you
once it's approved. Be sure to use the same name and email address.
This thread is now CLOSED. If you wish to comment, start a NEW discussion in
Access Expert 12.
