|
| If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|||||||
|
|
Thread Tools | Display Modes |
|
#1
March 22nd, 2007, 11:33 PM
posted to microsoft.public.excel.misc
|
|||
|
|||
Group Dates from SQL Query
I have the results of a SQL datasource providing the data for a pivot table.
Several of the fields are dates however I cannot group them like they were dates. How can I get the pivottable to understand which fields coming from my SQL datasource should be treated as dates? 
|
|
#2
March 22nd, 2007, 11:52 PM
posted to microsoft.public.excel.misc
|
|||
|
|||
|
Group Dates from SQL Query
I always parse them in a sql query to dd/mm/yyyy (with the slashes) using
SUBSTRING or similar -- HTH Nick Hodge Microsoft MVP - Excel Southampton, England DTHIS www.nickhodge.co.uk "wjvii" wrote in message ... I have the results of a SQL datasource providing the data for a pivot table. Several of the fields are dates however I cannot group them like they were dates. How can I get the pivottable to understand which fields coming from my SQL datasource should be treated as dates?
|
| Thread Tools | |
| Display Modes | |
|
|
Linear Mode
