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? |
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? |
All times are GMT +1. The time now is 02:11 PM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com