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?
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?
Thank You! That approach works.