Issue: We were facing an issue where a date column in an excel output was shown as 0-JAN-00 instead of the original date.
Cause: The reason is that when you create the excel(xls) BI Publisher template you have given the corresponding cell format as a date. Now in our case we had to convert the date to a TO CHAR format as MM/DD/YYYY. This meant that excel was not able to identify this as a date and hence defaulted it to 00-Jan-00
Resolution: You can resolve the issue by changing the type of the cell to 'General' from the the date format by going to format cells(right click).
Try exporting excel output again and check. Let us know if this did not solve your issue.
Read more on dates and Oracle BI Publisher at the Oracle blog.
when I gave to_char am not able to see date type filter (year-->month-->date) on the date columns. Complete date is coming in filter, just like it works in general type.
ReplyDeleteLet me know if we can handle this somehow.
Issue Resolved thanks
ReplyDeleteHi could you let me know how you fixed this issue, I am using BIP excel template and wanted to have date type filter as Year-->month--> date
DeleteHi could you let me know how you fixed this issue, I am using BIP excel template and wanted to have date type filter as Year-->month--> date
Deletehow did you fix this issue
ReplyDelete