COGNOiSe.com - The IBM Cognos Community

IBM Cognos 10 Platform => Cognos 10 BI => Report Studio => Topic started by: ravichandradama on 07 Aug 2013 08:39:38 AM

Title: Date prompt value need to display MM/DD/YYYY Not like July 2, 2013
Post by: ravichandradama on 07 Aug 2013 08:39:38 AM
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
Title: Re: Date prompt value need to display MM/DD/YYYY Not like July 2, 2013
Post by: Tseug on 07 Aug 2013 09:03:17 PM
you could try to_char([date],'MM/DD/YYYY')