How can I calculate age with the birthdate?

[Guest]

I went to the MS Office website and the answer provided didn't work. I have
a database that has the birthdate in there and also age. The age is merely
entered in by hand. I would like it to be a calculated value using the date
of birth and the current date. If you can help, I would be much appreciative.

 

[Allen Browne]

Use DateDiff() to get the difference in years, and adjust by one if the
person has not had their birthday yet this year. Details:
http://members.iinet.net.au/~allenbrowne/func-08.html

Don't store the age in the table. Just calculate it in a qeury when needed.
If that is a new idea, see:
Calculated fields
at:
http://members.iinet.net.au/~allenbrowne/casu-14.html

 

[John Vinson]

I went to the MS Office website and the answer provided didn't work. I have
a database that has the birthdate in there and also age. The age is merely
entered in by hand. I would like it to be a calculated value using the date
of birth and the current date. If you can help, I would be much appreciative.

The age should NOT be stored in the table: you can be absolutely
certain that all ages will be WRONG within a single year!

Instead, calculate it on the fly using a Query. In a vacant Field cell
type

Age: DateDiff("yyyy", [DOB], Date()) - IIF(Format([DOB], "mmdd") >
Format(Date(), "mmdd"), 1, 0)


John W. Vinson[MVP]
(no longer chatting for now)

 

[Lorenzo]

Try this

year(date()) - year(your_field_name)

L.

I went to the MS Office website and the answer provided didn't work. I have
a database that has the birthdate in there and also age. The age is merely
entered in by hand. I would like it to be a calculated value using the date
of birth and the current date. If you can help, I would be much

appreciative.

 

[Douglas J. Steele]

Except that that will give an incorrect result if they haven't yet had their
birthday this year.

See the other answers in this thread for more reliable approaches.

 

[Lorenzo]

Ok, my schema is reduced.
It's true in law-departments where only years are checked
about the age.

Thanks.
L.