Categories
Date Formatting - Excel Export
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
Answers
-
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.
0 -
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.
0 -
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
0 -
Thanks!
0