Calculating Age from a Specific Date

[Guest]

I need help. I'm getting very frustrated. I've read all the posts and
nothing is working. I'm trying to calculate DOB from a specific date
4/30/2006. I've added a unbound text box in my form and set the control
source to the following expression:
=DateDiff("yyyy",[DOB],#4/30/2006#)+(Format([DOB],"mmdd")>Format(#4/30/2006#,"mmdd"))

[DOB] is a field in my table for date of birth. But nothing is happening.
When I transfer back to the Form view to data enter. #Name? appears in the
box where my calculated date should be. Is there another way to calculate
the age from a specific date? What the heck am I doing wrong? I've been
working on this forever.

Thanks

 

[Allan Murphy]

Cris

Try this website
http://www.rogersaccesslibrary.com/download3.asp?SampleName=YearsMonthsDays.mdb
and download the zip file.

This will give the age of a person by using the start date as Date of Birth
and End Date to determine the person age on a particular day.

 

[Guest]

See my answer in your last post

 

[Guest]

I opended up the properties of one of the folmulas you had here for years and
it gave me what I needed to calculate my age. Thank you so much. I couldn't
figure it out the other way. This was much more simple. Math. Go figure.
I never even thought about doing it that way. Thanks again

Cris

Try this website
http://www.rogersaccesslibrary.com/download3.asp?SampleName=YearsMonthsDays.mdb
and download the zip file.

This will give the age of a person by using the start date as Date of Birth
and End Date to determine the person age on a particular day.

--
Allan Murphy
Email: (e-mail address removed)

I need help. I'm getting very frustrated. I've read all the posts and
nothing is working. I'm trying to calculate DOB from a specific date
4/30/2006. I've added a unbound text box in my form and set the control
source to the following expression:
=DateDiff("yyyy",[DOB],#4/30/2006#)+(Format([DOB],"mmdd")>Format(#4/30/2006#
,"mmdd"))

[DOB] is a field in my table for date of birth. But nothing is happening.
When I transfer back to the Form view to data enter. #Name? appears in the
box where my calculated date should be. Is there another way to calculate
the age from a specific date? What the heck am I doing wrong? I've been
working on this forever.

Thanks