extract the year and month from a date field

[gatorfe]

Hello, how can I  extract the year and month from a date field?  Currently the date field on the report shows as 2011-06-01 and I want to show it as 2011-06. Thanks in advance for any suggestions.

[cognos123]

Change Data Format default  to date  and  change properties for  date 

Date separator '-'
date ordering  'yr,month,day'
Display years 'Yes'
Display Months ' two digits'
Display days and weekdays 'No'

:)

[cognos123]

You can try this one also

TO_CHAR([dataitem],'YYYY - MM')