It looks very simple but a bit complicated question, what if I need to calculate the age from birth date in formula field whose return type is text?
Answer for Calculating Age From Birth Date :
Just copy paste this in your formula field, it will provide you the exact age calculated from birth date.
Secondly if the first scenario fails two options comes in my mind, if the month of present year is same then is day of birth is same or not so if day of birth is greater than or equals to day of birth than age is calculated as we have done in the first scenario.
Thirdly if above both scenarios fails that means month of present year and month of birth date is same but day of birth is smaller than day of present day. So age is calculated as the difference between present year and year of birth -1
See I told you it looks simple but bit complicated.
Cheers
Answer for Calculating Age From Birth Date :
Just copy paste this in your formula field, it will provide you the exact age calculated from birth date.
IF(MONTH(TODAY())>MONTH(DOB_API),YEAR(TODAY())-YEAR(DOB_API),IF(AND(MONTH(TODAY())=MONTH(DOB_API),DAY(TODAY())>=DAY(DOB_API)),YEAR(TODAY())-YEAR(DOB_API),(YEAR(TODAY())-YEAR(DOB_API))-1))First simply if the month of present year is greater than date of birth than age will be calculated as the difference between present year and year of birth.
Secondly if the first scenario fails two options comes in my mind, if the month of present year is same then is day of birth is same or not so if day of birth is greater than or equals to day of birth than age is calculated as we have done in the first scenario.
Thirdly if above both scenarios fails that means month of present year and month of birth date is same but day of birth is smaller than day of present day. So age is calculated as the difference between present year and year of birth -1
See I told you it looks simple but bit complicated.
Cheers
