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
Addendum to my question
Print screen of current Prompt values
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.