Using Excel Template, "Date" field Shows "01/00/1900"
(Doc ID 2532992.1)
Last updated on AUGUST 21, 2019
Applies to:BI Publisher (formerly XML Publisher) - Version 12.2 and later
Information in this document applies to any platform.
When Excel file (.xls) is used as the template for Excel report, "date" field is shown as "01/00/1900"
Some of the original values are 01/01/2018 and 06/30/2018.
They should be shown as 01/01/2018 and 06/30/2018, respectively.
The issue can be reproduced at will with the following steps:
1. Prepare xml file with the date value in the above format.
2. Create Excel template and map the field.
3. Create Excel report.
4. Date field shows "01/00/1900"
To view full details, sign in with your My Oracle Support account.
Don't have a My Oracle Support account? Click to get started!
In this Document