Text only | Text with Images

COGNOiSe.com - The IBM Cognos Community

IBM Cognos 8 Platform => COGNOS 8 => Report Studio => Topic started by: babukatra on 21 Oct 2009 04:55:29 AM

Title: How to change the Date formte in the Date prompt.
Post by: babukatra on 21 Oct 2009 04:55:29 AM
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.
Title: Re: How to change the Date formte in the Date prompt.
Post by: venunoise on 21 Oct 2009 05:11:57 AM
Use Data format to resolve this issue..
set date format as per the requirement.

Cheers
Venu
Title: Re: How to change the Date formte in the Date prompt.
Post by: venunoise on 21 Oct 2009 08:06:49 AM
If your issue doesn't resolved then use this

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


Cheers
Venu
Title: Re: How to change the Date formte in the Date prompt.
Post by: babukatra on 22 Oct 2009 01:21:33 AM
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.
Text only | Text with Images