OBIEE 11g/12c: Exporting Data to CSV Changes the Year Values
Last updated on APRIL 18, 2018
Applies to:Business Intelligence Suite Enterprise Edition - Version 22.214.171.124.0 and later
Information in this document applies to any platform.
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).
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