[AccessD] Date Diff Help

I am trying to do a an age calculation with the following
data source.

 

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

 

DOB is the employees date of birth.

 

If Dob is 5/11/1940 I am expecting to get 65 back not 172.

 

TIA

 

Joe Hecht

jmhecht at earthlink.net