Hi thankyou,
the date is formatted as *14/03/2001, it appears to be reconized as a date
for everything but the pivot table.

"Debra Dalgleish" wrote:

When you get the data from the query, the dates may be imported as text,
which would prevent them from being grouped. There are instructions here
for converting the text dates to real dates:

http://www.contextures.com/xlDataEntry03.html

sue wrote:
I have a spreadsheet that has been obtained from a external database query. I
am now trying to group the dates into months and years, however no luck. If I
save the worksheet as a csv file and the back into an excel file the date
grouping works fine. This however does not solve my problem.

hel please


--
Debra Dalgleish
Excel FAQ, Tips & Book List
http://www.contextures.com/tiptech.html