convert varchar date for link to Excel

[stocktondesigns]

I am doing a query in Excel, the OrderDate is stored in SQL as a varchar field. When imported to Excel, it is seen only as Text, not a Date, and requires conversion in Excel. Surely there is a way to format my view/query so that this field's date comes into Excel as a Date format and not text. Would appreciate any assistance on this.

 

[JohnDTampaBay]

What is the format of the date in the varchar column? You should be able to CAST or CONVERT the varchar data to a datetime datatype in the SELECT query.

SELECT CAST(DateColumn AS datetime) AS DateColumn
FROM SQLTable

--John
-----------------------------------
Behold! As a wild ass in the desert
go forth I to do my work.
--Gurnie Hallock (Dune)