How to format Date in BI publisher template in RTF in oracle fusion

 If you have date format in your data model then do not make any changes in data model. Let it be whatever it is.

For example : Select invoice_date from AP_INVOICES_ALL

so invoice date output should be : 2012-04-05T18:17:12.000+00:00

Now take XML data from the report and put that XML data into RTF template. 

Pull Tag Invoice_date into RTF template and change it properties like as below

Syntax: <?xdofx:to_date(TRX_DATE,'DD-Mon-YY' )?>

it will work, Now if there are multiple templates then we can change the data format for each template in template itself.

If we change date format via SQL Query (Data Model) then in that case it will work but it will be static not dynamically.

We can also try <?format-date:ASSIGNMENT_START_DATE?;'DD-MON-YYYY'?> if that works. But make sure data format in Data model should be standard.