Date Problem: Reports not showing 2002 Data

[jonesanne]

Since the new year, the only way my reports will show 2002 data is to change the setting on my computer to 12/31/02.

The report selection is based on two parameter fields, beginning date and ending date.The formulas in the report are calculated for each month, for example:

If {JOINALLSales Journal.product id} Like "CH??6"
and {JOINALLSales Journal.invoicedate} >= Date("01/01&quot
and {JOINALLSales Journal.invoicedate} <= Date(&quot;01/31&quot
Then ({JOINALLSales Journal.casesshipped}+{JOINALLSales Journal.bottlesshipped}/12)

Many thanks for any help!

 

[dgillz]

TRhis makes no sense becuase nothing in your formula refers to a CurrentDate or system date.

Can you post the record selection formula instead of this formula? I suspect that is where the problem lies. Software Sales, Training and Support for Macola, Crystal Reports and Goldmine
dgilsdorf@mchsi.com

 

[chelseatech]

I'd use a date formula of Date(y,m,d) to make things work better. I've never had any problems with that mechanism.

I have my doubts about date(string) with bits of the dates missing. Editor and Publisher of Crystal Clear

http://www.chelseatech.co.nz/pubs.htm

 

[jonesanne]

I didn't use the Date(y,m,d) in the formulas because we need a yearly picture of activity by month (Jan-Dec). The year would limit the formulas to one year wouldn't it?

I am using the Select Expert with the formula below:

{JOINALLSales Journal.invoicedate} in {?Beginning Year} to {?Ending Year}


Thanks,
Anne
chwjonesanne@aol.com