Use Control Source to calculate age

[wally]

I already have a date of birth field named DOB. I am trying to calculate age with full years, months, and days using the control source in a text box, but all I can get in return is the calculated years old and nothing else. Here is my code:

=DateDiff("yyyy",[DOB],Date())+Int(Format(Date(),"mmdd")<Format([DOB],"mmdd"))

What am I forgetting?

Thanks in advance!

 

[wally]

Tried this and it doesn't seem to work either...

=DateDif([DOB],TODAY(),"y") & " years " & DateDif([DOB],TODAY(),"ym") & " months " & DateDif([DOB],TODAY(),"md") & " days"

 

[wally]

Found this one too:

=DateDiff("yyyy",[DOB],Now())

Any way to add days and months to that?

 

[Severin]

Datediff is not reliably when calculating age, so I've made an example... Feel free to use it!~)