I need to display the benefits paid for the current year using SQl,but the year is filtered using the year which is previous year for the current year.the date is in 'yyyymm' format.
where year_mnth in ('200603','200602','200601') note:it is in 'yyyymm' format
group by year_mnth
the benefits paid must be calculated for the year 200603 to 200601
but the display is as follows,
May 12, 2008 6:59 AM
September 22, 2008 8:59 PM