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