SSRS 2012 Excel Renderer default date export issue - by MgManoj

Status : 

  Duplicate<br /><br />
		This item appears to be a duplicate of another existing Connect or internal item.<br /><br />
		A more detailed explanation for the resolution of this particular item may have been provided in the comments section.


10
0
Sign in
to vote
ID 783858 Comments
Status Closed Workarounds
Type Bug Repros 1
Opened 4/16/2013 7:12:17 PM
Access Restriction Public

Description

SSRS report having date field with data having default value of 1/1/1900 - if you try to export in SSRS 2012  to excel  the date value gets changed to 1/2/1900.   this happens excel 2007, excel 2010 also.  
Sign in to post a comment.
Posted by Irina [MSFT] on 9/20/2013 at 1:51 PM
Thank you for finding this issue. This is fixed in Cumulative update package 6 for SQL Server 2012 SP1 that was released on September 16, 2013 (available on Microsoft Download Center http://support.microsoft.com/kb/2874879).

Thanks,
Irina Gracheva
Microsoft
Posted by MgManoj on 7/15/2013 at 9:41 AM
I have installed the latest updates for Reporting Services 2012 and still see the same issue with the date when exporting to excel. Actually the dates from 1/1/1900 to 2/28/1900 all get incremented by 1 day.

Ignore the prior comment posted.
Posted by MgManoj on 7/15/2013 at 9:39 AM
I have installed the latest updates for Reporting Services 2012 and still see the same issue with the date when exporting to excel. Actually the dates from 1/1/1900 to 2/28/1900 all get incremented by 1 day when exporting to excel. It looks like it is probably a bug and I will report it to the product group.
Posted by MgManoj on 4/29/2013 at 10:37 AM
Only with 1/1/1900
Posted by Microsoft on 4/29/2013 at 10:14 AM
Does this issue appear with any other dates, or just with 1/1/1900?