How to get age from DOB

P

pokdbz

I have a DOB field (eg 5/23/03) how do I get there age from this date with
code?
 
J

jwm

pokdbz said:
I have a DOB field (eg 5/23/03) how do I get there age from this date with
code?
Click to expand...

In this example the DOB field is named "dtmBirthDate"...substitute your
field name.

=DateDiff("yyyy",[dtmBirthDate],Date())+(DateSerial(Year(Date()),Month([dtmBirthDate]),Day([dtmBirthDate]))>=Date())
 
Top