For info on the undocumented DATEDIFF function see Chip's site
www.cpearson.com
best wishes
--
Bernard V Liengme
www.stfx.ca/people/bliengme
remove caps from email

"pama" wrote in message
...
What is the best way to calculate the age of a person in number of years,
months, days, given their birth date?
Getting the difference between dates in number of days, and dividing by
365
may not be correct to the exact day given leap years. Is there another
way?