Oracle BI Publisher, RTF Template Date format
<p>I have used "Date, MM/DD/CCYY" under the <code>&lt;format&gt;</code> column in the RTF, when used in SQL developer I get proper output where CC is replaced with century(e.g. 03/07/2016 as per the format "MM/DD/CCYY" will be 03/07/2116 [21st century]) but in RTF I get the output as 03/07/CC16.<br>
I also tried TO_CHAR(FIELD,’MM/DD/CCYY’) but its not working. Can you please let me know the issue, why the format is not workin</p>