>>>Anyone know how to calculate the age from a date of birth in a sql statement.
>>>Date of birth is stored in a datetime field (DOB).
>>>
>>>Example:
>>>
>>>select lastname,firstname,dob,age
>>
>>
select lastname,firstname,dob, Datediff(Month, dob, getdate())/12 as age
>
>
>Sergey;
>
>I thought if I just asked my mother I could get a quick answer! :)
>
>Tom
Yea, it would work if you have a reference to the mother object. :)
--sb--