Hi Guys, In prompt page i am entering the date format as 'MM/DD/YYYY' in textbox prompt and in report and i want to display as "DD Mon YYYY" format.
I tried to find some options but none are working. Can you pl help me out.
cool way....
In Page header Query....... created data item to_char(TO_DATE(?Start?,'MM/DD/YYYY'),'DD Mon YYYY')
and used as singleton .