I am using formula: daysbetween(daydate("PERSON_BIRTH_DATE"),daydate(now()))/365
to calculate the person age and it is working fine. However the above column have default dates such as 31 Dec 9999 in some peoples date of birth and brings a negative answer in age calculation. In the instance where the Persons birth age is listed as 31 Dec 9999 I want to exclude it and overwrite that negative result with todays date using (now()).
I have been trying to put this in an if statement but i keep on getting a conversion data type error message. The person age column is data type INTEGER and the "PERSON_BIRTH_DATE" column is DATE data type. Thank you.