need to get the age

[sonny1974]

im using sql server and crystal xi

i have a DOB field ex. 5/18/1947. i need to subract the DOB from today (would change daily by it self,not a hard coded today date).

just the age would be fine.

but if i can get example 60 and 9 months that would be better.

 

[synapsevampire]

Here's Ken Hamady's (our local Crystal gurus) solution:

http://www.kenhamady.com/form06.shtml

To get months, attack it a different way:

whileprintingrecords;
numbervar AllMonths:=datediff("m",{table.dob},currentdate);
numbervar MyYears:=int(AllMonths/12);
numbervar MyMonths:= remainder(allmonths,12);
"You're " & MyYears & " and going on " & MyMonths & " Old."

A bit of a cheat because of the subjective nature of determining the number of months. What is Feb 28th to Mar 30th? It wasn't over a month yet, but the days say so...

Anyway, one or both of these might work for you.

-k

 

[sonny1974]

im geeting 66.00 and 2.00 months. how would i take out the 0's

 

[sonny1974]

any ideas how to get rid of the decimal

 

[synapsevampire]

Try:

whileprintingrecords;
numbervar AllMonths:=datediff("m",{table.dob},currentdate);
numbervar MyYears:=int(AllMonths/12);
numbervar MyMonths:= remainder(allmonths,12);
"You're " & totext(MyYears,0,"") & " and going on " & totext(MyMonths+1,0,"") & " Old."

-k