Age

[dave]

Hi

I have a field for Date of Birth. On my report I have the Date of Birth
shown but I also want to display the current age of the person. I have
played with =now()-[DOB] but it shows only a number.

Any ideas?

Thanks

 

[Allen Browne]

The basic idea is to use DateDiff() to get the difference in years, and then
subtract one if the person has not had their birthday yet this year.

Details:
http://members.iinet.net.au/~allenbrowne/func-08.html

 

[Douglas J. Steele]

Not clear what you're looking for, but since you're complaining that "it
shows only a number", I'm guess that you want something like 15 years, 2
months, and you're only getting 15.

If that's the case, take a look at
http://members.rogers.com/douglas.j.steele/Diff2Dates.html

If that's not the case, then Allen's answer is hopefully what you needed.