How to change date format in excel template in BI Publisher
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.