Oracle Analytics and AI

Format Date doesn't display month as upper case

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

Find more posts tagged with

Reporting

Accepted answers

All comments

Dir_Pal

Might be some help

https://docs.oracle.com/middleware/12211/bip/BIPRD/GUID-7BD3C665-851A-43FE-BA2D-7501390D95AC.htm#BIPRD2568

Dir_Pal

post ur sample xml and rtf template ur using can help u out.

User_U66J8

Hi,

Thanks for your answer, but I checked this before and I cannot see a solution or workaround.

Regards,

Aleks

Dir_Pal

attach ur rtf template..

Dir_Pal

Try the excel report and let me what issue ur getting over der instead of excel2000

Dir_Pal

https://docs.oracle.com/middleware/12211/bip/BIPRD/GUID-142C47DC-2B6F-4FB4-9512-4EA14467D9A0.htm#BIPRD3328

Swapna Kankipati

I tired both excel and excel2000, same issue.

Swapna Kankipati

The excel being generated is in xls format. Is because of the MS office version the format is giving issue ? Which office version should I get for formatting to work ?

Also my BI publisher is bit diff than yours, we are on R12.1 so I'm using BI publisher version 10.1.3.3.0.

Swapna Kankipati

I have excel 2010, which version did you try in ?

Dir_Pal