• I would convert all the dates to the first of each month and group on that value.  No parsing and concatenating of values required.

    dateadd(month,datediff(month,0,Datecol),0)