BI Publisher (MOSC)

MOSC Banner

help to format fiscal period in excel output

edited Apr 20, 2018 2:55PM in BI Publisher (MOSC) 3 commentsAnswered ✓

In RTF template I added column to show fiscal period but the excel output is converting to text.

The xml has tag showing as :

         <START_DATE>2018-01-01T00:00:00.000-05:00</START_DATE>

         <FISCAL_PERIOD>JAN-18</FISCAL_PERIOD>

whereas the excel output is formatting and showing : 

18-Jan

I have tried using below formatting in the item but nothing helps.

<?xdofx:to_char(START_DATE,'MON-YY')?>

<fo:bidi-override direction="ltr" unicode-bidi="bidi-override"><?FISCAL_PERIOD?></fo:bidi-override>

<?format-date:START_DATE;'MMM-YY'?>

I would like the fiscal period column output in excel to show as JAN-18

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

Don't have a My Oracle Support Community account? Click here to get started.

Category Leaderboard

Top contributors this month

New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center