AnsweredAssumed Answered

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

Question asked by derc on Mar 10, 2009
Latest reply on Mar 10, 2009 by 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.

 

 

 

 

 

Outcomes