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 AUGUST 07, 2024

Applies to:

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

Goal

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?


Solution

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
Goal
Solution

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