AnsweredAssumed Answered

Calculating Which Date Comes First

Question asked by ErickJ.Gonzalez on Feb 23, 2015
Latest reply on Feb 23, 2015 by philmodjunk


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,

Please HELP?!

Thank You!