My Oracle Support Banner

Why Can't the Date Format for XML/BI Publisher Reports be Changed From YYYY-MM-DDThh:mm:ss+HH:MM? (Doc ID 473042.1)

Last updated on FEBRUARY 04, 2022

Applies to:

BI Publisher (formerly XML Publisher) - Version to 12c [Release 10.1 to 12.0]
Information in this document applies to any platform.
Oracle XML Publisher - Version: 5.0 -
Reviewed for relevance 3 Nov 2016


When user double clicks on an XML/BI Publisher report field, changes the text form field type to Date and then changes the format to M/D/YYYY and then run the report, it comes out as YYYY-MM-DDThh:mm:ss+HH:MM...the full date string. Why isn't the date format in the rtf template working? Is there a workaround for this if user cannot rely on the built-in functionality of MS Word?


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

My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.