subracting for age

[sonny1974]

sql server and crystal xi

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

 

[onpnt]

Try using DATEPART

[sub]____________ signature below ______________
The worst mistake you'll ever make is to do something simply the way you know how while ignoring the way it should be done[/sub]

 

[AlexCuse]

onpnt - don't you also need DATEDIFF? ;-)

http://msdn2.microsoft.com/en-us/library/aa258269(SQL.80).aspx

Ignorance of certain subjects is a great part of wisdom

 

[onpnt]

derrr..leave it to the n00b right

[sub]____________ signature below ______________
The worst mistake you'll ever make is to do something simply the way you know how while ignoring the way it should be done[/sub]

 

[sonny1974]

how would i set up my formula?

 

[sonny1974]

sorry im kinda slow today,not sure what the formula should be

sorry

 

[onpnt]

Did you read over the function Alex posted?

[sub]____________ signature below ______________
The worst mistake you'll ever make is to do something simply the way you know how while ignoring the way it should be done[/sub]

 

[sonny1974]

oh didnt notice the link , ill check it out

 

[monksnake]

This will be to the month:

select datediff(mm, DOB, getdate()) / 12 years, datediff(mm, DOB, getdate()) % 12 months

note if days difference is listed at 367 days, that's 1 year and just a hair over. It will show as 1 year 1 month.

<.