Welcome to SPN

Register and Join the most happening forum of Sikh community & intellectuals from around the world.

Sign Up Now!

Calculating Age from a Specific Date

Discussion in 'Information Technology' started by Cris, Oct 31, 2005.

  1. Cris

    Cris
    Expand Collapse
    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
     
  2. Loading...

    Similar Threads Forum Date
    SciTech Calculating the Rarity of a Fingerprint Breaking News Dec 13, 2010
    Basics Of Sikhi Jagraj Singh Diagnosed With Stage 4 Cancer Sikh Organisations Dec 1, 2016
    1984 Images Revisited - YouTube History of Sikhism Nov 2, 2016
    50 Or So Pages Of DG Are By Guru Gobind Singh Other Scriptures Sep 9, 2016
    Interracial And Interfaith Marriage, Help Needed To Confront/convince My Parents Love & Marriage Aug 16, 2016

  3. Allan Murphy

    Allan Murphy
    Expand Collapse
    Guest

    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: allanmurphy@unwired.com.au

    "Cris" <Cris@discussions.microsoft.com> 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
    > the age from a specific date? What the heck am I doing wrong? I've been
    > working on this forever.
    >
    > Thanks
     
  4. Ofer

    Ofer
    Expand Collapse
    Guest

    See my answer in your last post
    --
    If I answered your question, please mark it as an answer. That way, it will
    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
    > working on this forever.
    >
    > Thanks
     
  5. Cris

    Cris
    Expand Collapse
    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

    "Allan Murphy" wrote:

    > 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: allanmurphy@unwired.com.au
    >
    > "Cris" <Cris@discussions.microsoft.com> 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
    > > the age from a specific date? What the heck am I doing wrong? I've been
    > > working on this forever.
    > >
    > > Thanks

    >
    >
    >
     

Share This Page