Calculateing age

  • Thread starter Thread starter John
  • Start date Start date
Hi

How can I calculate age from a given DoB?

Thanks

Regards
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)

You do know, I hope, that this Age computation should NOT be stored in
any table.
Just compute it and display it on a form or report, as needed.
 

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

subtracting 2 dates to calculate age; format as years days 4
Query: calc. age based on birth date 1
Calculate Age 3
Sorting dates by month 6
Creating a calculated field using dates in a form 3
Calculate AGE 5
AgeGroup 6
date calculations 5

Back
Top