Issue exporting Old dates data to Excel

[Former Member]

Hi,

We have a Date columns where we have dates as 1/1/0001. When the WebI Report is exported to excel the values for 1/1/0001 is showing up as ######## instead of 1/1/0001.

The users are fine if the excel shows up as 1/1/0001 instead of #########.

Has any one came across this issue and has any work around, so while exporting to excel it displays the date as in WebI.

Thanks

[former_member189638]

You can create a variables as below and use it in your table.

=If([DateObject]= ToDate("1/1/0001";"M/d/yyyy")) Then "1/1/0001" ELSE [DateObject]