Calculating Age from a Specific Date

#1 (**permalink**) 31-Oct-2005, 11:19 AM

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
Reference:: Sikh Philosophy Network http://www.sikhphilosophy.net/information-technology/6203-calculating-age-from-a-specific-date.html
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
Reference:: Sikh Philosophy Network http://www.sikhphilosophy.net/showthread.php?t=6203
working on this forever.

Thanks

#2 (**permalink**) 31-Oct-2005, 11:19 AM

Cris

Try this website
http://www.rogersaccesslibrary.com/d...MonthsDays.mdb
Reference:: Sikh Philosophy Network http://www.sikhphilosophy.net/showthread.php?t=6203
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: allanmurphy@unwired.com.au

"Cris" wrote in message
news:6F812418-01BB-49A0-A10B-CB84CFD5DD48@microsoft.com...
> 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
Reference:: Sikh Philosophy Network http://www.sikhphilosophy.net/showthread.php?t=6203
> the age from a specific date? What the heck am I doing wrong? I've been
> working on this forever.
>
> Thanks

#3 (**permalink**) 31-Oct-2005, 11:19 AM

See my answer in your last post
--
If I answered your question, please mark it as an answer. That way, it will
Reference:: Sikh Philosophy Network http://www.sikhphilosophy.net/showthread.php?t=6203
stay saved for a longer time, so other can benifit from it.

Good luck

"Cris" wrote:

> 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
Reference:: Sikh Philosophy Network http://www.sikhphilosophy.net/showthread.php?t=6203
> working on this forever.
>
> Thanks

#4 (**permalink**) 31-Oct-2005, 11:19 AM

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

"Allan Murphy" wrote:

> Cris
>
> Try this website
> http://www.rogersaccesslibrary.com/d...MonthsDays.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: allanmurphy@unwired.com.au
Reference:: Sikh Philosophy Network http://www.sikhphilosophy.net/showthread.php?t=6203
>
> "Cris" wrote in message
> news:6F812418-01BB-49A0-A10B-CB84CFD5DD48@microsoft.com...
> > 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.
Reference:: Sikh Philosophy Network http://www.sikhphilosophy.net/showthread.php?t=6203
> > 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
>
>
>