I am trying to calculate age for dateof birthcloumn.
I have following code
DEFINE FILE STAGE_CHILD_POS
CURRENTDT/Y=&DATEYYMD;
Birthday/YYMD=HDATE(STAGE_CHILD_POS.STAGE_CHILD_POS.BIRTHDATE, 'YYMD');
AGE/D12.2=DATEDIF(Birthday, CURRENTDT, 'Y');
END

I am getting error message:
(FOC36355) INVALID TYPE OF ARGUMENT #2 FOR USER FUNCTION DATEDIF
What am I doing wrong?

Arif

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

The field, CURRENTDT, is just a number. DATEDIF is expecting a date-formatted item.

If you just want to subtract the birth year from the current year, extract the birth year and do it arintmetically.

If you're wanting to calculate age from a date of birth, you should be subtracting today's date and the date of birth. Just using today's year may or may not give you the correct age. It would depend on whether or not the birthday has already occurred in this year.

Change your code as follows:

DEFINE FILE STAGE_CHILD_POS
  CURRENTDT/YYMD=&YYMD;
  Birthday/YYMD=HDATE(STAGE_CHILD_POS.STAGE_CHILD_POS.BIRTHDATE, 'YYMD');
  AGE/D12.2=DATEDIF(Birthday, CURRENTDT, 'Y');
END

Hi,

Can you use the following to determine age?

DEFINE FILE SOMETABLE  
AGE/I3=BIRTHDATE/365.25;
END

Best Regards,

Jimmy Pang

quote:

DEFINE FILE STAGE_CHILD_POS
CURRENTDT/YYMD=&YYMD;
Birthday/YYMD=HDATE(STAGE_CHILD_POS.STAGE_CHILD_POS.BIRTHDATE, 'YYMD');
AGE/D12.2=DATEDIF(Birthday, CURRENTDT, 'Y');
END

I think it was very helpful. I used
DEFINE FILE STAGE_CHILD_POS
CURRENTDT/YYMD=&YYMD;
Birthday/YYMD=HDATE(STAGE_CHILD_POS.STAGE_CHILD_POS.BIRTHDATE, 'YYMD');
AGE/D12.2=DATEDIF(Birthday, CURRENTDT, 'Y');
END

and it works just fine.

quote:

Can you use the following to determine age?

DEFINE FILE SOMETABLE
AGE/I3=BIRTHDATE/365.25;
END

Jimmy, you can do that if you want the wrong answer. What that calculation will give you is an estimate of the number of years since 1/1/1901. Smart dates (those with a format of YYMD or MDYY or DMYY, etc.) are stored internally as the number of days since 12/31/1900. -1 is 12/30/1900, 0 is 12/31/1900, 1 is 1/1/1901, 2 is 1/2/1901, etc. If Birthday is 7/13/2005, as an integer it is 38180, divide that by 365.25 you get 104.53... years.

I see.

Thanks for your response to describe what it's actually doing in the calculation.

I better double check some old report as they may not be correct.

Thanks again.