Hello, Can someone recommend the best way of calculating age in years, mont

Question

Hello,
Can someone recommend the best way of calculating age in years, months and days, by taking only a birth date / start date?

Taking into consideration leap years and difference in days of the month, as they might be 28,29,30 or 31 days.

Example input would be: 1/10/2014 [1st October 2014]
Result on 2/4/2015 [2nd April 2015] would be: 0 years 6 months 1 days

Thanks

Anurag · Answer

I have created expression rule to calculate age (in year) based on birth date. Below is for reference, can be modified further to get month and days also: 
 
 if( month(today())>month(ri!dob), year(today())-year(ri!dob), if( month(today())<month(ri!dob), year(today())-year(ri!dob)-1, if(day(today())<day(ri!dob), year(today())-year(ri!dob)-1, year(today())-year(ri!dob) ) ) )

Hello, Can someone recommend the best way of calculating age in years, mont

Top Replies