Date "DD/MM/YYYY" in Dashboard Prompt Returning Format "DD/MM/YYYY HH:MI:SS" (Doc ID 1356649.1)

Last updated on JULY 17, 2017

Applies to:

Business Intelligence Server Enterprise Edition - Version: 10.1.3.4.1 [1900] and later   [Release: 10g and later ]
Information in this document applies to any platform.

Symptoms

Created a date prompt and associated it with Calender Object. When the prompt is used in a report, it can filter data successfully and see the same in the report. However the format of filter value changes to "DD/MM/YYYY HH:MI:SS from "DD/MM/YYYY" upon clicking the 'Go' button .

For example: Original format  is like 1/9/2011, After Press the "Go" Button, It Changes to 1/9/2011 00:00:00.


Cause

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