nav[aria-label="Primary Navigation"] { padding: 0; & ul { list-style: none; width: 100%; display: flex; flex-direction: row; justify-content: start; align-items: start; gap: 30px; padding: 0; & li { margin: 0; } & ul li { list-style: none; } } }

Oracle Communities

Oracle Analytics and AI

Child Item

Difference in date format between .xlsx and .csv file in obiee 12c

3364275

Hi Team,

In obiee 12c we found a different issue while exporting the report into .xlsx format and .csv format. In .xlsx format date value is showing correct (17-may). But same report in .csv format it is showing (17-06-2018). which is wrong. It should show (17-06-2017). Please help me on this.

Note: These column is direct pull from the database.

Thanks in Advance.

Regards,

Somi R Chinta.

Find more posts tagged with

Accepted answers

All comments

Joel Acha

Looks like an Excel issue and how it is interpreting your "date". OBIEE is doing what it has to but and it appears to be exporting it correctly as "17-Nov".