Date of Birth

[Guest]

I would like the formula for determining a person's age. For example: One of
my fields says: "Date of Birth" and the other field "Age." What is the
formula I should use to determine that person's age in a query? Any
assistance would be greatly appreciated. Thank you!

 

[Allen Browne]

You can grab this function to calculate the person's age:
http://allenbrowne.com/func-08.html

Paul, I trust you understand that you do not put an Age field in your table?
You use a query to generate the person's age, and that way you don't have to
update your table every day. If that's a new idea, see:
Calculated fields
at:
http://allenbrowne.com/casu-14.html

 

[Guest]

Yes Allen I know that I should not put an Age field in my table but in the
query. However I am confused about the formula that you referred to in your
article. Can you simply give me the formula. I am new at ACCESS. Thanks for
your help.

 

[Van T. Dinh]

If you want to use Allen's function, you need to copy it to a standard
module and the use the function in your Query, e.g. a calculated Field like:

AgeAsAtToday: Age([DOB])

In you want a simple expression, try:

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

 

[John Vinson]

Can you simply give me the formula.

The formula I use is:

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

John W. Vinson[MVP]