Date Formatting - Excel Export

Matt M

Summary

Can't filter by year and month on OTBI export

Content

When exporting my analysis to excel the date column is not formatted so I can filter by year, month and day as shown in the attached screenshot comparison.  Does anyone have a solution or workaround?

Thanks!

Matt

Prudence K

Hi Matt - the easiest way that I have found (without seeing your screenshot - doesn't look like it was attached?) is to highlight the column with the dates and then replace / with /  Not sure why that matters, but then it works as a date column. 

Matt M

Thanks!  That worked!  I would still be interested if anyone has a solution for correcting at the source.  Seems like there should be a format setting.

Reena Trangri

This is a very old known issue and expected to be fixed in next OBI version upgrade. There have been earlier many related posts on the same providing the workarounds to have this resolved at our end.

Pls. find below some posts discussing the same issue

https://cloudcustomerconnect.oracle.com/posts/41852cf1ad

https://cloudcustomerconnect.oracle.com/posts/f61de2937e

Regards,

Reena Trangri

Matt M

Thanks!