grouping mass date data

[jaylo]

I am trying to group some data, at the moment its pullin the info as
individual dates but i need them to be in some sort of group ie.
months/weeks. Ive tryed to group via the field but its says i can group it
that way. Any ideas ? ie.

 

[Peo Sjoblom]

You can group dates using a pivot table