Categories
- All Categories
- 15 Oracle Analytics Sharing Center
- 15 Oracle Analytics Lounge
- 208 Oracle Analytics News
- 41 Oracle Analytics Videos
- 15.7K Oracle Analytics Forums
- 6.1K Oracle Analytics Idea Labs
- Oracle Analytics User Groups
- 76 Oracle Analytics Trainings
- 14 Oracle Analytics Data Visualizations Challenge
- Find Partners
- For Partners
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
Answers
-
follow this link
Johny's Oracle Tips: BI Publisher: Format Date in XML/BI Publisher
0 -
Use
<?xdoxslt:ora_format_date(CREATION_DT,'mm/d d/yyyy')?>
or
<?xdoxslt:format_date(Date Field,'dd/MM/yyyy','yyyy-MM-dd',$_XDOLOCALE,$_XDOTIMEZONE)?>
or
place date field in RTF template ,open form field then select desired format and apply changes, Thanks
0 -
None of the option worked which are mentioned above .
0 -
Please try below
<?xdofx:to_char(to_date(replace('2017/12/21','/','-'),'YYYY-MM-DD'),'dd-mon-yyyy')?>
0