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 NOVEMBER 03, 2016

Applies to:

BI Publisher (formerly XML Publisher) - Version 10.1.3.4.1 to 10.1.3.4.2 [Release 10.1]
Information in this document applies to any platform.
Oracle XML Publisher - Version: 5.0 - 10.1.3.4.1
Checked for relevance on 27-AUG-2013
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

Sign In with your My Oracle Support account

Don't have a My Oracle Support account? Click to get started

My Oracle Support provides customers with access to over a
Million Knowledge Articles and hundreds of Community platforms