How to get age from DOB

[Guest]

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

 

[Van T. Dinh]

See The Access Web:

http://www.mvps.org/access/datetime/date0001.htm

 

[jwm]

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

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())