Add date format in Prompt of OBIEE

Rai Qaiser Hussain · Jan 25, 2019 6:21AM

Hi

I want to add date format in promot of dashboard and followed the following document but fail

How to Dispaly date type data to a format such as 'DD/MM/YYYY' (Doc ID 963352.1)

Used below query in SQL of Prompt

SELECT EVALUATE('TO_CHAR("Time"."Calendar Date")',"Time"."Calendar Date" , 'DD/MM/YYYY')

FROM "Data Management"

ORDER BY "Time"."Calendar Date" DESC FETCH FIRST 5 ROWS ONLY

what is wrong with this query/ format used

Rai Qaiser Hussain · Jan 25, 2019 6:58AM

Addendum to my question

Print screen of current Prompt values

Rai Qaiser Hussain · Jan 25, 2019 11:29AM

No error also no data return

I can't set same format for all the dashboards, i am using different date formats on different dashboards.

MFA for Oracle Community