Grouping dates in pivot table


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.
 
Ad

Advertisements

B

Bob Umlas, Excel MVP

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
 
H

Herbert Seidenberg

Search criteria:
OLAP Pivot Table date 2007
Advanced Search > microsoft.public.excel.*
 
Ad

Advertisements

M

Marc

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 -

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

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top