I have downloaded abot 20,000 lines of data. One of the columns in the data
is a date field. The dates begin in 2004 and continue through 2008. The dates
in the downloaded file would look like this 06/25/04 so on and so on. I want
to be able group the data in a pivot table by month and year. The only way I
have been able to think to do this is to open a new column and change the
06/25/04 date to read 06/01/04. This would allow me then to report inside a
pivot table for the month of June 2004. IS there a simpler way to do this
without having to create a new column or is there a way to simply change the
DAY for all date ranges to be 01?

Assuming that your dates are actual dates and not text then that is built
into pivot tables. Ensure that all of the values are true dates and that
there are no blanks in th list. If you need to make any fixes to accomplish
taht then refresht the pivot table twice (don't ask but trus me you need
might need to do it twice).

Add the date filed to your pivot table. Right click the date field and
select Group. It will give you the option to group by month and year and...
--
HTH...

Jim Thomlinson


"Mike" wrote:

I have downloaded abot 20,000 lines of data. One of the columns in the data
is a date field. The dates begin in 2004 and continue through 2008. The dates
in the downloaded file would look like this 06/25/04 so on and so on. I want
to be able group the data in a pivot table by month and year. The only way I
have been able to think to do this is to open a new column and change the
06/25/04 date to read 06/01/04. This would allow me then to report inside a
pivot table for the month of June 2004. IS there a simpler way to do this
without having to create a new column or is there a way to simply change the
DAY for all date ranges to be 01?