My Oracle Support Banner

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

Last updated on NOVEMBER 14, 2019

Applies to:

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


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.


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.