Yrdif FUNCTION using Numeric BEST12 Format to Calculate Age

[mglogan]

Hello, I am trying to calculate an age variable.

The input format of brth_date (birth date) and scrn_date (screening date) is datetime 22.3.

the output format is numeric best12.

I am receiving the error: "Invalid character data" (Log below) 

Any help would be appreciated.

Thank you!!

brth_date = datepart (brthdat);

if recorddate > . then scrn_date = datepart (recorddate);
else scrn_date = datepart (icdat);

age = floor(yrdif (brth_date, scrn_date,'age'));

[Jagadishkatam · Accepted solution]

Could you please check if you have the age already derived in DM1 dataset. 

[mglogan]

Wow, so when I initialized the variables in the dm1 data set, I accidentally set age = ' ' instead of age = . 

Thank you!