2 Replies Latest reply on Mar 10, 2009 4:46 PM by derc

    actual age calculations from DOB calculations- getting neg numbers and "2009"

    derc

      Title

      actual age calculations from DOB calculations- getting neg numbers and "2009"

      Post

      I have a date of birth field with a calculation that is as follows:

      =Getasdate(GetasText(GetAsNumber(mo birth)&"/"& Getasnumber(daybirth)&"/" &Getasnumber(yrbirth))).

       

      I then have an actual age field with a calculation that is as follows:

      =INT((Today-DOB)/365)

       

      You are only allowed to put in two digits for the year of birth. Although some of the actual ages are correct, here is a sample of what I am getting:

       

      dob is 8/03/35- actual age given as -26

      dob is 15/01/34- actual age is given as -24

      dob is 11/20/36- actual age is given as 2009

      ANY BRIGHT PERSON KNOW WHAT IS WRONG HERE? I AM NEW TO FMP AND CAN'T FIGURE IT OUT. THANKS.