Hi Mike

There is no inherent reason why the date field cannot be grouped having come
through MSquery.
If the dates in the csv file are genuine dates, AND if there are no blank
date fields, then the PT will group them.

I would try just opening the csv file in Excel, by double clicking on it.
Examine the data and see if there are problems in the date field. If so,
amend them and save back as csv, then your link to the PT should work fine.
--
Regards
Roger Govier

"mike" wrote in message
...
Hi All,

I have a .csv file produced by our accounting software Exchequer
containing
my data which contains the following:

Department
Invoice Value
Invoice Date

I have linked this data as an external datasource to a pivot table but am
unable to group the "Invoice Date" field. I am assuming this is becuase
MS
Query is taking the invoice date field as text and not as an actual date
OR
that the header is MS Query is making it not possible for me to groupt the
Invoice Date Data. Before I have only been able to get pivot tables to
group
by date if only the Data is selected and not the header.

Please can anyone help?

Many thanks in advance

Mike