Group Dates from SQL Query

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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?
 
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
(e-mail address removed)
www.nickhodge.co.uk
 
Back
Top