How to change the Date formte in the Date prompt.

[babukatra]

Hello Friends,

Can any one please help me on the Fallowing issue.


I created one date prompt In report page when I select the date in the date prompt edit box it is displaing the Format as "Jan 31 2008" in the Prompt box.

But the Client need " MM/DD/YYYY" formate with in the prompt box.

Can any one please help Me how to resolve this.

[venunoise]

Use Data format to resolve this issue..
set date format as per the requirement.

Cheers
Venu

[venunoise]

If your issue doesn't resolved then use this

to_char(date,"MM/DD/YYYY") for the prompt display value


Cheers
Venu

[babukatra]

Thx All,

But my requirement is I need to show that Date formate with in the Prompt box not in the Report output.

Ex The Date prompt is Edit box With in the Edit box I need to show that date Formate. MM/DD/YYYY insted of (MMM-DD-YYYY)

I checked there is no data Formate proparty for date Prompt.

Can any one please Help me How to rsolve this.