Date of Birth

Stewart · Mar 16, 2004

Can anyone tell me what I need to put in a calculated
query field in order to work out someones exact age from
their date of birth.

Much appreciated.

Stewart

Douglas J. Steele · Mar 16, 2004

Depends what you mean by "exact age"

If all you want is their age in years, try:

Age=DateDiff("yyyy", [DoB], Date()) - _
IIf(Format(Date(), "mmdd") < Format([DoB], "mmdd"), 1, 0)

If you want their age in years, months and days, check out "A More Complete
DateDiff Function" at
http://members.rogers.com/douglas.j.steele/Diff2Dates.html

How do I get ACCESS to calculate years, months, days for a birth d	2	Jun 3, 2008
Calculating age	3	Jan 24, 2010
How do I post a result of a query to a text box?	0	Jul 28, 2015
age calculation using field date of birth by query	1	Aug 1, 2008
Birthday Date	6	Jul 23, 2009
Calculating age from date of birth and ignoring if blank	5	Nov 24, 2010
Format Date	1	Feb 6, 2010
Date of Birth	4	Dec 15, 2003

Date of Birth

Stewart

Douglas J. Steele

Ask a Question

Similar Threads