You'll find that the equation won't accurately show the age. If the birthday
hasn't been reached yet in the current year, it'll still show the person one
year older. You will find a better, one line formula here:
http://www.mvps.org/access/datetime/date0001.htm
Once you have that, it is still necessary to determine age in 10ths of a
year.
If you modify the formula to
DateDiff("ww", [BirthDate], Date())+Int(Format(Date(), "mmdd") < Format(
[BirthDate], "mmdd"))
You will get weeks instead of years. Dividing by approximately 52.19 (number
of weeks in a year) and rounding to 1 decimal place will give you years and
tenths of years.
--
Wayne Morgan
MS Access MVP
NewLifeAl said:
The following formula displays in full years only:
=(DateDiff("yyyy",[BirthDate],Now())). How can it be altered to display
years and 10ths of years. AARGH.