Display Format for Date Prompt - Report Studio

[rm1234]

I am using a Date Prompt and have set the properties Select UI = 'Edit Box' and Calandar Type = 'Gregorian'.

My query is do we have any facility to set the display format of this date prompt.

Currently it displays 'Sept 10,2007'. I want to display '10.09.2007'

Is there any option to do this?

Thanks

 

[BICentre]

Hello, I would start by taking a look at the .js files for each prompt control and see what is their default format.

...Cognos\c8\webcontent\prompting

http://bicentre.blogspot.com

Wallace Taylor

http://bicentre.blogspot.com

 

[JPCogAdmin]

rm1234 (MIS),

You can do that by first creating a filter. In that filter write the query for how you want to format your database date! The date is coming from the database correct? Format depends on the specific db vendor. However, you should know the format for your database type. Next, when you create the promopt, select an existing variable (the variable you created when you defined the filter. That should do the trick.

Let me know how it turns out.

-Jim

 

[ax4208]

Hi,
I have the same problem.Prompt data is showing month as 'Sep' but I need to show as September .I failed to change through Data Format button.How can I do this ?
Would u please tell me what statement should I write for filtering?
Please help me.
Thank you.