OBIEE 11g/12c: Exporting Data to CSV Changes the Year Values

(Doc ID 2384163.1)

Last updated on APRIL 18, 2018

Applies to:

Business Intelligence Suite Enterprise Edition - Version 12.2.1.2.0 and later
Information in this document applies to any platform.

Symptoms

You have exported the results of an analysis to CSV, when you open the file on Excel you notice that the dates are changed from MMM-YY to MM-DD-YYYY.

Also, the displayed date is incorrect.  For example, your data has values like "JAN-17" (January of 2017) and this is converted by Excel to "17-Jan" (January 17 of 2018).

Changes

 

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