Date Problem

[rhurd]

I am using Parameters to pick start and end dates for a monthly report. I put in start 06/01/03 12:00:00AM to 11/30/2003 11:59:59PM. on the report it shows 06/02/03 to
06/30/03 then 07/02 Why 07/02

Dick Hurd

 

[synapsevampire]

Probably because you don't have any data for 7/1.

Crystal doesn't fabricate data (dates), so if you want it to show something that isn't there, you'll have to code for it.

This can be accomplished in different ways, but depending upon your environment, something along these lines might suit you:

faq767-4532

-k

 

[rhurd]

I Put date ranges from 01/01/03 to 11/30/03 and each month starts with 01/02/03, 02/02/03, 03/03/03

 

[dgillz]

Please post your record selection formula.

Software Sales, Training, Implementation and Support for Exact Macola, eSynergy, and Crystal Reports

http://www.trianglepartners.com

 

[synapsevampire]

As dgillz points out, it sounds like your excluding the 1st in your record selection formula.

Or the data doesn't have the first...

When you right click the section and select change group, does it have group by Month?

If so, the default display wouldn't include a day anyway (since it's a monthly report, why would you show a day?), so you're doing something differently.

You can format the date field to only show month/year, which makes more sense.

-k

 

[rhurd]

{picture.datestamp}>= {?Start Date} and
{picture.datestamp} <= {?End Date} and
{picture.operator} = {?Operator}