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

"Marc" wrote:

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

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

On Nov 18, 11:23*am, Bob Umlas, Excel MVP
wrote:
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



"Marc" wrote:
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.
.- Hide quoted text -

- Show quoted text -

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