Change the date format

[EArumugam]

How the change the date format for Paramdisplayvalue('date').

I need to display the selected date in Header of the report page.

when i used paramdisplayvalue, it display inthe format Oct 12, 2009.

How to change the format of date to MM/DD/YYYY.

* i change the date format in property but failed.

its urgent.

[Gopinath]

Create a data item in your query using your prompt parameter like

cast(?date? as date)

Display this data item in the report header and change the format.

[dumbell]

As they say there are diff ways to go to Rome, cast(to_char(....) also helps.

[sriniv]

Data item idea working but the prompt is converting as required prompt. Basically this date prompt is optional prompt in the report, Any clue how i can make this as optinal date prompt ?