Peter Gore wrote:
I need to add a computed column to a table to evaluate a person's age. >What is the best way to calculate age? DateDiff(Year, BirthDate, >CURRENT_DATE) seems only to take account of the year portion of the >dates and not the month and day parts.
Helen Borrie answers:
(DateDiff(Month, BirthDate, CURRENT_DATE)) / 12.00