Crosstab Query using Convert

I'm trying to convert the MYSQL query below to work with my current CF Report. It is stopping at the CONVERT statement..?

--------------------------------------------------------------------------

SELECT CONVERT(varchar(8),cfmDate,1) AS 'Month',
       SUM(CASE WHEN DATEPART(month,cfmDate) = 1 THEN 1 ELSE 0 END) AS 'Jan',
       SUM(CASE WHEN DATEPART(month,cfmDate) = 2 THEN 1 ELSE 0 END) AS 'Feb',
       SUM(CASE WHEN DATEPART(month,cfmDate) = 3 THEN 1 ELSE 0 END) AS 'Mar',
       SUM(CASE WHEN DATEPART(month,cfmDate) = 4 THEN 1 ELSE 0 END) AS 'Apr',
       SUM(CASE WHEN DATEPART(month,cfmDate) = 5 THEN 1 ELSE 0 END) AS 'May',
       SUM(CASE WHEN DATEPART(month,cfmDate) = 6 THEN 1 ELSE 0 END) AS 'Jun',
       SUM(CASE WHEN DATEPART(month,cfmDate) = 7 THEN 1 ELSE 0 END) AS 'Jul',
       SUM(CASE WHEN DATEPART(month,cfmDate) = 8THEN 1 ELSE 0 END) AS 'Aug',
       SUM(CASE WHEN DATEPART(month,cfmDate) = 9 THEN 1 ELSE 0 END) AS 'Sep',
       SUM(CASE WHEN DATEPART(month,cfmDate) = 10 THEN 1 ELSE 0 END) AS 'Oct',
       SUM(CASE WHEN DATEPART(month,cfmDate) = 11 THEN 1 ELSE 0 END) AS 'Nov'

       SUM(CASE WHEN DATEPART(month,cfmDate) = 12 THEN 1 ELSE 0 END) AS 'Dec'

FROM      tblStatus RIGHT OUTER JOIN tblCalixFilterMaint ON tblStatus.statusID =

tblCalixFilterMaint.cfmStatus LEFT OUTER JOIN tblColloNode ON tblColloNode.NodeID

= tblCalixFilterMaint.cfmCollo
GROUP BY CONVERT(varchar(8),cfmDate,1)
ORDER BY CONVERT(varchar(8),cfmDate,1)

------------------------------------------------------------------------------

Here is the link to the original author of this code:http://www.sqlteam.com/article/counting-transactions-per-hour-using-a-pivot-table

Thanks,

jlig