Date changes when grouped

[Andie]

I have a date field that appears to be changing when it is used as a group. The field "Period" is of type date/time. In the database (Access) the field is also date/time. The period should be the first of each month, ie 10/01/06, 11/01/06, etc. This is true in the database. It is also true if I browse the data in Crystal or when the field is in the detail section of the report. When I browse the data the periods come up as 10/01/2006 12:00:00am.

However, I need to group on this field so I can count the number of records associated with each period. This is where the problem is occuring. Here is how the groups appear:
10/01/06 (correct)
10/29/06 (should be 11/01/06)
11/26/06 (should be 12/01/06)
12/31/06 (should be 01/01/07)
01/28/07 (should be 02/01/07)
02/25/07 (should be 03/01/07)
04/01/07 (correct)
04/29/07 (should be 05/01/07)

I have verified that the format is set as mm/dd/yy for this field in Crystal.

Any ideas of what might be going on and how I can fix it? I am using Crystal Standard 11.0 and it is connecting to Access 97.

Thank you.

 

[lbass]

It looks like you might be grouping on change of week versus on change of month. Go to the group expert->your group and check out the selection.

-LB

 

[Andie]

That did it. Thanks!