Age, Total months t be displayed

[Tia]

Dear,

I have a list of employees birthdate and i am trying to find out how
much is the age and total month.
I am using this formula and all i am gettng is total years.
Age: DateDiff("yyyy",[Birthdate],Date())+(Format([Birthdate],"mmdd")

Format(Date(),"mmdd"))

Please help

 

[Douglas J. Steele]

See "A More Complete DateDiff function" at
http://www.accessmvp.com/DJSteele/Diff2Dates.html

Age: Diff2Dates("ym", [Birthdate], Date())

Note, of course, that Age will now be a text field, so you won't be able to
do arithmetic on it.

--
Doug Steele, Microsoft Access MVP

(no private e-mails, please)

Dear,

I have a list of employees birthdate and i am trying to find out how
much is the age and total month.
I am using this formula and all i am gettng is total years.
Age: DateDiff("yyyy",[Birthdate],Date())+(Format([Birthdate],"mmdd")

Format(Date(),"mmdd"))

Please help