Calculate age

  • Thread starter Thread starter Wei
  • Start date Start date
W

Wei

If I know the age of a person, for example 7/24/1982.
And I want to know the exact age of this person up to
today. (say today is 2/6/2004.)
What should I do?

Thanks.

Wei
 
If I know the age of a person, for example 7/24/1982.
And I want to know the exact age of this person up to
today. (say today is 2/6/2004.)
What should I do?

Thanks.

Wei
Click to expand...
In a query:
Age: DateDiff("yyyy", [DOB], Date()) - IIF(Format([DOB], "mmdd") >
Format(Date(), "mmdd"), 1, 0)

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

Change [DOB] to whatever your [Date of Birth] field is named.
 
Back
Top