IIF statement to choose latest date

M

Marge

I have an employee database that tracks, among other things, promotion,
transfer and reassignment dates. I have allowed for 9
promotion/transfer/reassignment events in the database. For various reasons,
some PTRs will change an employee's annual evaluation date and some will not.
I'm using a yes/no checkbox as a field to flag those PTR dates that will
change the evaluation date. How do I tell the database to use the most
recent of the nine yes/no date as the adjusted evaluation date, and if there
is no PTR yes/no, to use the original hire date?

Any support you can give will be appreciated. Thank you.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

selecting the most recent date 1
Can I use an IIF statement with the NZ function? 2
IIf statement 4
Date differential between a full date and a date that has a year and month. 5
Date Brackets as an IIf statement 3
Query to select values after a certain date 0
Query User Defined date range 2
Need One Query to Search Multiple Date Fields, If Possible 4

Top