Calculating Difference in Months, Days 2

[szeiss]

Using Crystal 8.5 with Oracle 8i backend. I have an end date using the CurrentDate function of CR and a start date called "PrevYear" which is a calculated field that finds the last day of the previous fiscal year (9/30/2003). I need to know how many months and days have elapsed since 9/30/2003 thru CurrentDate shown in this format 4.15.

Thanks,
Sherry

 

[bdreed35]

Take a look at the DateDiff function in the help. You can use it to get both the Months and the Days.

@Months_Difference

DateDiff("m",{table.PrevYear},{table.ThisYear})

Would give you the months difference

@Days_Difference

DateDiff("d",{table.PrevYear},{table.ThisYear})

Would give you the days difference

~Brian

 

[mbarron]

Try this one:

datevar begin:= date(2003,09,30);
datevar end:= currentdate;

numbervar months:=datediff("m",begin,end);
numbervar begpart;
numbervar endpart;

datevar beginlast:= date(dateadd("m",1,begin)-1);
datevar endlast:= date(dateadd("m",1,end)-1);
begpart:=day(begin)/(beginlast - begin + 1);
endpart:=day(end)/(endlast - end );

months - begpart + endpart

Mike

 

[szeiss]

Thanks, exactly what I was looking for.

Sherry