Calculating age in a label or text box on a form

G

Guest

Hello All,
I have a text box for birthdate for a user to enter the birthdate and I want
to the age for the user to be automatically calcuated and displayed in
another label called "Age." What formula can I use?
Missy
 
G

Guest

=DateDiff("yyyy", [Birthdate], Now())+ Int( Format(now(), "mmdd") < Format(
[Birthdate], "mmdd") )
 
G

Guest

Thank You Dennis. It worked perfectly .

Dennis said:
=DateDiff("yyyy", [Birthdate], Now())+ Int( Format(now(), "mmdd") < Format(
[Birthdate], "mmdd") )


Umm Husina said:
Hello All,
I have a text box for birthdate for a user to enter the birthdate and I want
to the age for the user to be automatically calcuated and displayed in
another label called "Age." What formula can I use?
Missy
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

Age, Total months t be displayed 1
Display Calculated Fields and Save Data on Form 2
age calculations 2
Hello happy new year to all, Text box input for year of purchase 0
Open Form depending on criteria 2
Calculating age with If statement 2
Calculating customer AGE 5
calculate age on certain date 2

Top