I am trying to convert a varchar2 type xml field to date in rtf. The field has FND_STANDARD_DATE value set in the EBS application but this value is getting stored in the DFF of irc_offers table and hence it is of type varchar2. The value getting stored in the table is something like '2018/09/21 00:00:00' format. I want this to be displayed as 21-09-2018 or 21-Sep-2018 in my rtf. I have tried various syntax like <?xdofx:to_char(to_date(attribute5,'YYYY/MM/DD HH24:MI:SS'), 'DD-MM-YYYY') or <?format-date:attribute5;'DD-MM-YYYY'?>. Both dont seem to have any effect in the output. Whatever I try to do, I am only seeing the same '2018/09/21 00:00:00' in my output. Can anyone please help me with this issue?
PS: This isn't an rdf report. The XML is generated by OfferLetterDetailsVO which is a standard one provide by oracle. I am using this standard xml to build my custom template for irec offer letters.