Oracle Analytics Cloud and Server

Welcome to the Oracle Analytics Community: Please complete your User Profile and upload your Profile Picture

Format Date doesn't display month as upper case

Received Response
573
Views
22
Comments

Summary

Format Date doesn't display month as upper case

Content

Hi All,

 

 

I'm using OTBI release 12 and I have a BI publisher predefined report.

I have a field where I want the date to be displayed with the following date mask : DD-MON-YYYY. It works almost correct, but the month is not uppercase(e.g. not APR but Apr). Any ideas?

 

Here is the source I use:

 

 

<?format-date:(xdoxslt:ora_format_date_offset(xdoxslt:sysdate('YYYY-MM-DD'),7,'+'));'DD-MON-YYYY'?>

 

 

Thanks in advance,

Aleks

Tagged:
«13

Answers