Calculating Which Date Comes First
I manage a program where participants are eligible for 3 years of service from the day they arrive to my area or until they turn 22 years old (which ever comes first). What calculation can I use to determine the participant's Expiration Date (the date they are no longer eligible for services)?
I have a the following fields in my layout:
Today's Date (calculated), DOB (Date of Birth), QAD (Qualifying Arrival Date) and Expiration Date.
Again, they are eligible for 3 yrs from the QAD or until their 22nd birthday, whichever comes first.
I am self taught out of necessity,