Oracle Fusion BI Publisher: Export To Excel From BIP Report - Date Format Is General And Doesn't Convert To Date (Doc ID 2080882.1)

Last updated on NOVEMBER 21, 2015

Applies to:

Oracle Fusion Global Human Resources Cloud Service - Version 11.1.9.2.0 and later
Information in this document applies to any platform.

Symptoms

Problem Description
---------------------------------------------------
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

Sign In with your My Oracle Support account

Don't have a My Oracle Support account? Click to get started

My Oracle Support provides customers with access to over a
Million Knowledge Articles and hundreds of Community platforms