Oracle Analytics and AI

Home
Oracle Analytics and AI
Oracle Analytics and AI Forums
Oracle Analytics Forums
Oracle Analytics Forum

Desired date format in RTF template

Summary

Desired date format in RTF template

Content

Hi All,

I want to change the date format of an input date parameter from MM/DD/YYY OR any input date format to DD-MON-YYYY, e.g. FROMJ 'YYYY/MM/DD HH24:MI:SS TO DD-MON-YYYY

I Want to change that tag into RTF.Can anyone please help me out

Regards,

Ankush Tiwari

Find more posts tagged with

Accepted answers

All comments

Venkat Thota - BIP

follow this link

Johny's Oracle Tips: BI Publisher: Format Date in XML/BI Publisher

Venkat Thota - BIP

Use

<?xdoxslt:ora_format_date(CREATION_DT,'mm/d d/yyyy')?>

<?xdoxslt:format_date(Date Field,'dd/MM/yyyy','yyyy-MM-dd',$_XDOLOCALE,$_XDOTIMEZONE)?>

place date field in RTF template ,open form field then select desired format and apply changes, Thanks

Ankush Tiwari-89813

None of the option worked which are mentioned above .

Brajesh Shukla-95078

Please try below

<?xdofx:to_char(to_date(replace('2017/12/21','/','-'),'YYYY-MM-DD'),'dd-mon-yyyy')?>