excel importing date field as text from sql server
Posted on 2011-02-25
I've set up a data connection to sql server for a pivot table and a date field is coming over as text instead of a date. If I run the same query in sql server management studio, copy the results onto a sheet, that same field is in a date format.
How can I get the data connection to do the same thing?
the field in question source is
CONVERT(VARCHAR(25),DATEADD(dd,-(DAY(Install.StartDate)-1),Install.StartDate),101) AS Dated