actual age calculations from DOB calculations- getting neg numbers and "2009"
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:
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.