Using Excel Template for BIP Report - How do you get date fields to output in date format.
Using Oracle BI Publisher desktop 12.2.5.5.0 on EBS r12.2.9
We have an Excel template that outputs a report with some date columns. The problem is the date columns are not recognised as date in the Excel output report and they cannot be sorted or filtered on as date values.