Rolling Accounting Periods

[tcimis]

We have a report which we total certain information by accounting period. Example; if sysdate falls in period 2, the report would have Past, Period 2, Period 3, ..., Period 11, Period 12, Future.
The past column is not picking up information for the last week in January. We have had this report for 2 1/2 years but this is the first time someone has reported a problem.
We currently use Crystal 8.5 but the report was originally written in Crystal 6. We were using a 4-4-5 accounting period although it looks like they may be changing.

The code for the past is:

If{RCIIN038B.SCHED_DATE} <
If month({@Head0}) = 1 then date(year(currentdate),1,1) else
{@Period} + [0,28,63,91,119,154,182,210,245,273,301][month({@Head0})-1]+1
then {RCIIN038B.QTY_SCHEDULED} else 0

Any help would be greatly appreciated.

 

[synapsevampire]

Here's a good thread on this:

http://www.tek-tips.com/viewthread.cfm?qid=288394

Since you didn't include what's in {@Head0} or {@period} I won't speculate as to your difficulty.

-k

 

[tcimis]

Thank you. I found the issue late Friday and corrected.