Calculating age in a label or text box on a form

  • Thread starter Thread starter Guest
  • Start date Start date
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
 
=DateDiff("yyyy", [Birthdate], Now())+ Int( Format(now(), "mmdd") < Format(
[Birthdate], "mmdd") )
 
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...
 
Back
Top