Grouping dates in pivot table

  • Thread starter Thread starter Marc
  • Start date Start date
M

Marc

I am pulling data from a SQL Server database to create a pivot table.
Excel (07) is not recognizing the field as a date. This is a field I
would like to group by in the pivottable. I am aware of all the
techniques to convert this to a date field, but I am searching for an
answer as to why XL pivot tables cannot consume the dates directly
from a sql query.

I have played with bringing the dates back in a number of differenent
formats with no success.

Any insights into this would be appreciated.
 
Probably coming in as text and yuo may only need to copy an unused cell and
paste special values + "Add" to convert them to all real dates that yuo can
then group
 
Search criteria:
OLAP Pivot Table date 2007
Advanced Search > microsoft.public.excel.*
 
Probably coming in as text and yuo may only need to copy an unused cell and
paste special values + "Add" to convert them to all real dates that yuo can
then group







- Show quoted text -
Click to expand...

This is true. The trick is consuming the data directly from the query
which should be possible.
 
Back
Top