Categories
- All Categories
- Oracle Analytics Learning Hub
- 30 Oracle Analytics Sharing Center
- 19 Oracle Analytics Lounge
- 239 Oracle Analytics News
- 45 Oracle Analytics Videos
- 16K Oracle Analytics Forums
- 6.3K Oracle Analytics Idea Labs
- Oracle Analytics User Groups
- 88 Oracle Analytics Trainings
- 16 Oracle Analytics and AI 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