Export To Excel From BIP Report - Date Format Is General And Doesn't Convert To Date

 

Symptoms

After you export the BI Report to excel, the date format is shown as  general in Excel and doesn't convert to date.

This way you cannot filter on the date Columns even if you change their format to Data.

Cause

The issue is with Microsoft Excel where it does not recognize the Date due to a Tab Delimiter appended to the Date Value

Solution

Please use the following workaround in Microsoft Excel to convert the date columns from General to Date Select the date column in question.

1. From the File Menu, choose Data => Text to Columns.
2. On first screen leave the radio button on "delimited" and click Next.
3. Uncheck any of the delimiter boxes (any boxes blank; no check marks) and click Next.
4. Under column data format choose the Date Format you want.