Crystal Reports - Group By datetime

[tuber]

I'm doing a Group By on my report and I want to do it by a datetime field. I want it to group by date only. I only have 1 datetime field in my table, no other dates are stored.

However when I set it up and groups it by a date that not even in my table.

It puts 3/22/2009 as the only group. There isn't even a 3/22/09 in my table.

Why is it doing this? and how to I get it to group correcting my date only? Is this possible since there are times involved.

Hopefully I explained this well.

Thanks!

[rasinc]

Try assigning the date-time field to a date variable in a formula and use the formula for the grouping.