Date formatting - SQL to Excel
Posted on 2013-01-28
I have a field in SQL Server 2008 table that is a 'date' datatype.
I have an Excel 2010 spreadsheet that pulls inforation from a view that uses this field.
In SQL Server, the date is in the format: 'yyyy-mm-dd'.
The view contains this converstion to attempt to get it in the format 'mm/dd/yyyy'.
CONVERT (NVARCHAR(10), REPORTING_DATE, 101)
When refreshed, it is the mm/dd/yyyy format. However, it is still a string. It is not a date.
Any way for it to pull in as a date?