Unable to display Ordinal Number in small font in RTF Layout

Question

Summary

Content

Hi,

Am trying to display date in my report in the format "1st June 2017" which is of a rtf output but the system prints as 1st June 2017 instead. Can anyone guide me on how to get the rtf out with the format which am looking for.

Tried below options

<?xdoxslt:sysdate(‘ddth Month YYYY’)?>

to_char(sysdate,'fmddth Month YYYY')

Not able to get the required format.

Thanks,

Manju

Brajesh Shukla-95078 · Answer

You want SYSDATE to print like this or there is some other dates?

Brajesh Shukla-95078 · Answer

For this you need to add FO code to your rtf. Please split date in three formats 'DD', 'th' and 'MON YYYY', for all three add BI publisher tag and add the below code for each tag DD :

th:

MMM YYYY:

Regards, Brajesh