Data Model With Input Date Parameter Shows Wrong Values

(Doc ID 2331689.1)

Last updated on NOVEMBER 28, 2017

Applies to:

BI Publisher (formerly XML Publisher) - Version 12c and later
Information in this document applies to any platform.

Goal

Data Model has an Date Parameter as Input. When creating a parameter of type 'Date' there is the possibility to change the date format in 'Date Format String' property.

Date Format String Property is set as 'yyyy-mm-dd'.  The selected Date value is changed to another value and the query is not showing proper values.

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