Date prompt value need to display MM/DD/YYYY Not like July 2, 2013

[ravichandradama]

I am very new to Cognos Report Studio, I need help on Date Prompt Value Display.


My Client, Selected date need to be display like MM/DD/YYYY. But default select format like  is  July 2, 2013


Please help me

[Tseug]

you could try

Code Select Expand

to_char([date],'MM/DD/YYYY')