Date difference to show in years and months

[Owl]

Question 1 (the most important of the 3 related questions)
I have a date of birth field(DOB) and I want to get the age in current years
and months to display e.g. as follows:

63 years 11 months

I tried to work it out from reading similar questions and answers on
Discussions, but haven't been able to.

This is as far as I have got.

Age: (DateDiff("yyyy",2,Date()-[DOB]))

Question 2
When I used (DateDiff("yyyy",1,Date()-[DOB])) I got the date on this year's
birthday whether the birthday had arrived or not. When I put in a 2 instead
of the 1, I got the correct number of completed years. What does the 1 or
the 2 designate?

Question 3
Today being 19/09/2009 (South Africa - GMT + 2) and the time I was doing
this was about 9.30am, I found that if I had the birthday as being e.g.
19/09/1972 I got the correct answer - 37 completed years. If I had the
birthday being 17/09/1972, I got the correct answer (36 completed years).
However, if I had the birthday as 18/09/1972 I got the wrong answer of 36
completed years instead of 37. Why?

Thank you for any help.

 

[kc-mass]

Go here for three options to calculate age:
http://www.mvps.org/access/datetime/date0001.htm

Regards

Kevin

 

[Douglas J. Steele]

Check "A More Complete DateDiff Function" at
http://www.accessmvp.com/djsteele/Diff2Dates.html