Posted by: R Manimaran | June 25, 2008

Crystal Report XI – Calculate Age in Years

Number var DOB:=IIF(100*MONTH(CURRENTDATE)+DAY(CURRENTDATE))<

(100*MONTH({table.BirthDate})+DAY({Table.Birthdate})),1,0);

Numbervar Yr=DateDiff(“yyyy”,{table.Birthdate},Currentdate)-DOB;

yr;


Leave a response

Your response:

Categories