Categories
- All Categories
- Oracle Analytics Learning Hub
- 19 Oracle Analytics Sharing Center
- 17 Oracle Analytics Lounge
- 233 Oracle Analytics News
- 45 Oracle Analytics Videos
- 15.9K Oracle Analytics Forums
- 6.2K Oracle Analytics Idea Labs
- Oracle Analytics User Groups
- 87 Oracle Analytics Trainings
- 15 Oracle Analytics Data Visualizations Challenge
- Find Partners
- For Partners
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
Answers
-
-
post ur sample xml and rtf template ur using can help u out.
0 -
Hi,
Thanks for your answer, but I checked this before and I cannot see a solution or workaround.
Regards,
Aleks
0 -
Try the excel report and let me what issue ur getting over der instead of excel2000
0 -
-

0 -
excel 2013 is ur excel output is in .xsl or .xslx
0 -
which excel version ur using..
0 -
<?xml version="1.0" encoding="UTF-8"?>
<DATA_DS>
<G_1>
<SYSDATE>2018-04-06T10:54:08.000-05:00</SYSDATE><FISICAL_PERIOD>APR-06</FISICAL_PERIOD>
</G_1>
</DATA_DS>
If this one is upload in rtf and shown output in excel it shows me in all caps in .xlsx excel output
0 -
attach ur rtf template..
0