excel importing date field as text from sql server
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
Work with freelancers specializing in everything from database administration to programming, who have proven themselves as experts in their field. Hire the best, collaborate easily, pay securely, and get projects done right.