date arithmetic

[Alincon2001]

When I subtract one date from another, the result is in days. How can I get the result in years?
ie date of birth 2/1/1980
report date 5/1/01
person's age should show as 21.25 years, not 7700 days.
21 years and 3 months would also be a good format
Thanks in advance

 

[MalcolmW]

DateDiff() can give you the result in years (integer result).
Also,
DateSerial(0,0,PrintDate - {BirthDate}) will give you an result in a date format(ie years, months, and days old). This can be formatted to show all or part of the info.
Malcolm Wynden
I'm for sale at

http://wynden.net

malcolm@wynden.net