I just want to group my dates in a pivotchart by months or weeks to get
sales or weight sums by the month or week. Problem is that the chart won't
allow me to group the dates--it says that this type of data cannot be
grouped. why? why? why?

the dates in the cells also have time info:
i.e.
7/1/2004 9:53:07 AM

so when I put the Date field into the Category area of the chart it plots
every row down to the second! I'm lost and confused and searched the whole
newsgroup but can't find any postings of this same issue.

it seems like something common. can anyone help?

thanks,
kamal