>I am looking for some command or code that could hep in getting the number of Years and Days between Two Dates.
> For example, if commence_date='31/03/2011' and Current_date is '31/03/2013', I need Y=2 and D=1.
>
>Similarly if if commence_date='20/02/2012' and Current_date is '31/03/2013', I need Y=1 and D=41 ( as 2012 was a Leap Year).
>
>Kinldy Help

CLEAR
ldDate1 = DATE(2012, 2, 20)
ldDate2 = DATE(2013, 3, 31)

lnYears = YEAR(ldDate2) - YEAR(ldDate1)
IF MONTH(ldDate2) < MONTH(ldDate1) OR;
   DAY(ldDate2)   < DAY(ldDate1)
   lnYears = lnYears - 1
ENDIF

ldDate3 = GOMONTH(ldDate1, 12 * lnYears)

lnDays  = ldDate2 - ldDate3
? "Y:", lnYears,"D:",lnDays

NOT TESTED!!!