I can't get a SQL Server date field to format as a date. I have tried short date, long date, custom formatting including hours/minutes/seconds, and everything is interpreted as 0. If I use an existing connection and put it into a table report all dates display as expected. If I put them in a pivot (using direct ODBC, not a range in another sheet) I get the 1/0/1900 again. The query is basically:
SELECT MAX(PayDate) FROM MyTable
I have even tried a simple query like this with the same results.
SELECT 'ABC' AS Category, CAST('03-25-2014' AS DATE) AS MyDate
I have seen other posts relating to VLOOKUPs and similar issues but none of those responses seem to fit what I'm seeing.
The pivot just does a max aggregation of a date. This makes is seem like MAX of a date is perfectly "legal".
http://www.techrepublic.com/blog/mic...bset-in-excel/
Any ideas?
Thanks.
Bookmarks