Date problem in Pivot Tables when using SQL as a Data Source.

[smonczka]

Date problem in Pivot Tables when using SQL as a Data Source.

I have a table of sales information in SQL that shows the week ending
totals for our sales and the total sale price for that week. I am
using Excel to create a pivot table to access this table information so
that end users can automaticly look up the total weekly sales at any
time without having to come bother me I am not having any problems
making the pivot table and connecting to the SQL data. But all dates
come in as numbers, i.e. 1/4/2006 would show up as week "1" or
quarter "1" or day "4" but not 1/4/2006. The problem is when I
create a pivot tables with week ending sales totals each week in the
table shows up as a number, 1 - 52 and this confuses the users. What
I want to show is the actual week ending date not the number of the
week. Is this possible?

Thanks
Steve

 

[smonczka]

Just in case anyone else is having this problem, the solution is to use
the "Group By..." function within the pivot table. By using this
function you can group dates together and have them show up as actual
TEXT dates such as Jan, Feb, Mar instead of 1, 2 and 3.

Thanks
Steve