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.
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'
:)
You can try this one also
TO_CHAR([dataitem],'YYYY - MM')