BI Publisher (MOSC)

MOSC Banner

How to change date format in excel template in BI Publisher

edited Oct 27, 2019 5:01AM in BI Publisher (MOSC) 9 commentsAnswered

Hi,

I am creating an excel template in BI publisher.

I have the dates coming from XML in JDE.

But when I am previewing the excel after giving Format cells-> Date format (dd-mm-yyy)

In the output it is coming as 00-01-1900

What can be done to display the date in dd-mm-yyyy format. The xml holds the date in MM-D-YYYY format.

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