Skip to Content
Jul 21, 2018 at 06:40 PM

Calculating Person Age


Hi Community,

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.