Thanks, It working fine Now for all conditions
Thanks a lot
>>Sir,
>>Not working properly, If comm_date is 19/10/2011 and cur_date is 31/03/2013.
>>It should be 1 Year and 165 Days (13+30+31+31+29+31).
>>
>>Knidly Help
>
>Am I correct in assuming that if comm_date is 19/10/2010 and cur_date is 31/03/2012. It should be 1 Year and 164 Days? (13+30+31+31+28+31)
>
>If so, please try:
>
>
>CLEAR
>ldDate1 = DATE(2011,10,19)
>ldDate2 = DATE(2013, 3, 31)
>
>lnYears = YEAR(ldDate2) - YEAR(ldDate1)
>IF MONTH(ldDate2) < MONTH(ldDate1) OR ;
> ((MONTH(ldDate2) = MONTH(ldDate1)) AND (DAY(ldDate2) < DAY(ldDate1)))
> lnYears = lnYears - 1
>ENDIF
>
>ldDate3 = GOMONTH(ldDate2, -12 * lnYears)
>
>lnDays = ldDate3 - ldDate1 + 1
>? "Y:", lnYears,"D:",lnDays
>
Harsh