Changing the date format in Cognos10.1 Report Studio

[GGowtham]

I have a date column in Sql Server in (date data type), when I try to change the style of that date in report studio date format options
its not reflecting any change.

Options tried
1)Changed the data type to date using cast function and set the options as desired
2)Settings data format options in the properties
3)Setting the style in Data-->Default Data Formats-->Date and properties as desired.

Please advise how to change the stlye
To: "Full Month, date (2 digits), Year(4digits)" (eg) : April 02,2013
From : "YYYY/DD/MM"

[MFGF]

Hi,

It should simply be a matter of selecting the item in your report and using the Data Format property - selecting the Date data type, then setting the Ordering, Year, Month and Day options as follows:



Where is the item being used?

Regards,

MF.

[HDA]

The formatting for date with date seperator as ',' give the results as April,02,2013. How can I remove date separator after month. I need space after month. Eg: April 02,2013

Please advise.

[bdbits]

Do you have any other options set other than what is shown in the dialog MFGF showed? I just verified that his settings produce the results you want. I am guessing you may have a comma "," in the Date Separator property. Get rid of that and I think you will get what you wanted.