Skip to Content
0
Former Member
Jun 09, 2007 at 05:50 AM

Difference between two dates is required in years & months

17 Views

Hi all,

<b>1.</b> I want difference of two dates in years & months. For e.g. date1 is 29.09.1998 & date2 is 02.05.2001. I want date2-date1 to be calculated & displayed as 2.7 (yrs)in BEx.

<b>2. </b> Also, while calculating overalll result it should calculate as :

E.g. 2.7+ 2.6 = 5.1 (yrs)

Right now I am getting difference in days. Is there any way to convert it in yrs & months.

Note:string 'yrs' is not required

Thanks in advance.

Himanshu