Dates not recognized as dates in pivot table pulling directly from SQL Server
Solution 1:
Try casting your date to datetime.
SQL Server's date is internally represented as a 3 byte integer whereas datetime is 8 bytes and presumably floating point. Excel uses a double to represent dates/times so SQL Server's datetime format might map across better than date.