COGNOiSe.com - The IBM Cognos Community

IBM Cognos 8 Platform => COGNOS 8 => Framework Manager => Topic started by: pdaprem on 15 Mar 2011 07:07:58 AM

Title: Need to Display Short Month in RS and QS Reports
Post by: pdaprem on 15 Mar 2011 07:07:58 AM

I'm using DB2 and have used monthname to extract the month text for a date field. I now want to display the month as the short name 'Jan' in reports. I have tried using the Date format to indicate display short name but in my Report Studio reports the month is coming out 'January'. Without using a case statement any suggestions on how to make the Date format in the Properties pane work?
Title: Re: Need to Display Short Month in RS and QS Reports
Post by: PRIT AMRIT on 15 Mar 2011 09:43:27 AM
Not sure if I understood your query though, if you have date field and u want to just show the Month part alone with the short name, then just select that DATE column, go to Data Format properties, select type Date, then you can select all the default option as NO and for month, just select 'Short'.

Hope this is what you r looking for?
Title: Re: Need to Display Short Month in RS and QS Reports
Post by: pdaprem on 15 Mar 2011 09:58:40 AM
Thank You! That approach works.