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;

Advertisements

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s

Categories

%d bloggers like this: