Working out age using months and years

[#1]

Hi,

I am trying to calculate a persion age using 3 different fields, taking the Date of Birth and the Start date calculating the age and then adding the duration to find out the age at expiry. Taking the example below  this person would be 69 years 7 months. I am having problems with the duration part of this. I am looking to do this at the loader stage.

Start Date       25/02/2015

Date of Birth    31/01/1969

Duration          36 months

Answer 69.07

Any help would be great.

[rubenmarin]

Hi Marie, if I use:

=Date(AddMonths('25/02/2015', 36)- date('31/01/1969'), 'YY.MM')

Returns 49.01, 46.01 is the difference and adding the 36 months gives 49.01, how should be the calculations to return 69.07, can you explain step by step?

[#3]

Thanks Ruben, the correct answer is 49.01 for the example

[sunilkumarqv]

Check the result  in attached

give your feedback so we can work on that@

[#5]

Thanks Sunil, I have looked at this in this instance the Ager would show as 46.01.

[#6]

Thanks everyone, this has been answered on another thread.