Age from DOB calculataion

I

Ilya

Hi Everybody
Is there a function for accurate calculation of Age from DOB (Date Of Birth)
Thanks in Advance, Ilya.
 
J

Jim/Chris

In a Form or report
Directly as the control source of an unbound control:
=DateDiff("yyyy",[DOB],Date())-IIf(Format([DOB],"mmdd")>Format(Date(),
"mmdd"),1,0)

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

Jim
 
G

Guest

Int(now()-[DOB])

Ray
-----Original Message-----
In a Form or report
Directly as the control source of an unbound control:
=DateDiff("yyyy",[DOB],Date())-IIf(Format([DOB],"mmdd")
Format(Date(),
"mmdd"),1,0)

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

Jim
-----Original Message-----
Hi Everybody:
Is there a function for accurate calculation of Age from DOB (Date Of Birth)?
Thanks in Advance, Ilya.
.
Click to expand...
.
Click to expand...
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Display weeks from a Milestone 0
How do you round a number DOWN (for age)? 2
Calculating age from a DOB field 4
calculate age from DOB 1
#error in calculate age 4
Using Year of Birth, from DOB, in later calculations 6
Age calculation in Query 6
Age calculator 1

Top