I have a column in my View script that I convert to varchar(10) and want to convert it back to a date for the output to be in excel. Here is the original line
CONVERT(VARCHAR(10), d.DocDate, 110) AS [Invoice Date]
I have tried this line with no luck.
CONVERT(VARCHAR(10), CONVERT(DATETIME, d.DocDate), 110) AS [Invoice Date]
Can someone confirm if I have the right lines in the sql liine? Or I'm open to another way of writing it out.