Birth Date Calculator

[CEV]

I have a form that has a textbox for the Date of Birth for people. This
textbox is linked to a field in a table. I want to add another textbox on
this form that is not linked to any table. I want this textbox to display
the current age of people based on the date of birth from the other textbox.
What formula do I put into this new textbox?

Thanks,

Chad

 

[Brendan Reynolds]

See the first item in the list at the following URL ...

http://www.mvps.org/access/datetime/index.html

 

[Guest]

Hi Chad

Use this

=DateDiff("yyyy",[DateOfBirth],Date())-IIf(Format([DateOfBirth],"mmdd")>Format(Date(),"mmdd"),1,0)

DateOfBirth is the field name where the date of birth is stored.

 

[CEV]

Thanks Wayne. Worked perfect!!

Chad

Hi Chad

Use this

=DateDiff("yyyy",[DateOfBirth],Date())-IIf(Format([DateOfBirth],"mmdd")>Format(Date(),"mmdd"),1,0)

DateOfBirth is the field name where the date of birth is stored.

--
Wayne
Manchester, England.
Enjoy whatever it is you do

I have a form that has a textbox for the Date of Birth for people. This
textbox is linked to a field in a table. I want to add another textbox on
this form that is not linked to any table. I want this textbox to display
the current age of people based on the date of birth from the other
textbox.
What formula do I put into this new textbox?

Thanks,

Chad