I need to find members of a population who will be turning 65 within the next 90 days. At first this sounded simple, but as I got into the code I realized this is a little more complex than I originally thought. I have the individuals dates of birth and I have successfully calculated the correct age, but it is the ‘turning 65 within 90 days’ that is throwing me off.

Any suggestions on calculating a persons age on a future date?

This message has been edited. Last edited by: ChadSS,

Lets convert years into days.
65 years = 65*365 days = 23725 days

Now lets work backwards; 23725 days - 90 days = 23635 days.

If a person current age is greater than or equal to 23635 days then they will turn 65 within 90 days

So their 90th bday would fall in the range (today+1, today+90), right? In order to retrieve records where date of birth is in the appropriate range, you'll need to calculate those two 90-th bday end-point date values (say as &date1, &date2), subtract 90 years from each (&date3, date4), and apply

where dob from '&date3' to '&date4';

I was able to accomplish by doing the following:

DEFINE FILE XFILES
TODAY/I8YYMD = &YYMD;
DAY90/I8YYMD = AYMD(TODAY, 90, 'I8');
DAYS90/YYMD = DAY90;
AGEIN90/I5 = DATEDIF(BRTH_DT, DAYS90, 'Y');
AGE_FLAG/A1 = IF AGEIN90 EQ '65' AND AGE EQ '64' THEN 'Y' ELSE 'N';
END