When data is export from Analysis, date is showing in different format:

Simi_SS

Summary:

When data is export from Analysis, date is showing in different format:

Export>Data>Excel… then date is exported in different format.

Required Format : dd/MM/yyyy

export format is : MM/dd/yyyy (in both cases, when we try cast and also custom date format)

Content (please ensure you mask any confidential information):

Content (please ensure you mask any confidential information):

Version (include the version you are using, if applicable):

Code Snippet (add any code snippets that support your topic, if applicable):

Rajasekhar Bandaru-Oracle

Hi

Please refer to the existing post for the similar issue

https://forums.oracle.com/ords/apexds/post/obiee-12c-custom-date-format-issue-while-exporting-the-repo-7761

Bhaskar Konar

https://community.oracle.com/products/oracleanalytics/discussion/26080/when-data-is-export-from-analysis-date-is-showing-in-different-format

Hi @Simi_SS,

Welcome to the Oracle Analytics Community.

Are you downloading the data using the 'Formatted' tab?

If you are using the 'Formatted' tab option then it should keep the format that you used in the report.

Hope this help.

Thank you.