Displaying age in months or years using DateDiff

[SaneN85]

Ok, I'm not sure what happened to my first thread, but I am going to post again. I currently am using the Date diff formula to get the age of patients.

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

This displays the age of the patient in years, so if the patient is 3 months old, it is displayed as 0. What I am trying to do, is get it to display 3 months old (or whatever the correct month of patient's age) if they're under 1 years old. If they are over 1 (the majority will be), to display as their age in years. Is this even possible? If so, any help is appreciated.

 

[MazeWorX]

use an IIF statement

something like .. untested

=IIf(DateDiff("yyyy",[DOB],Now())+Int(Format(Now(),"mmdd")<Format([DOB],"mmdd"))<1,DateDiff("mm",[DOB],Now())+Int(Format(Now(),"mmdd")<Format([DOB],"mmdd")),DateDiff("yyyy",[DOB],Now())+Int(Format(Now(),"mmdd")<Format([DOB],"mmdd")))

HTH << MaZeWorX >> "I have not failed I have only found ten thousand ways that don't work

 

[dhookom]

Consider using and re-using the versatile function A More Complete DateDiff Function from Doug Steele.

Duane
Hook'D on Access
MS Access MVP