One of my users enlightened me on an error I had not forseen: if the user inputs an adult client's birthdate with THIS YEAR instead of the actual birthdate. I.e., 1/12/1940 becomes 1/12/2009. Suddenly someone who should be Medicare-eligible is WIC-eligible! ( ...American/social work joke)
Anyway, we do have pediatric clients, so I don't want to BLOCK dates <1. I just want a pop-up to catch the careless user.
Here's what I'd like:
If (birthday) < TODAY()-365,
Then Msgbox "Is client an infant? If no, correct birth year." [Yes] [No]
I hope this is easier than my last question...