This works.

SELECT DATEPART(mm, Dates) AS month,DATEPART(yy, Dates) AS year FROM
testing

Eugene Anthony

*** Sent via Developersdex http://www.developersdex.com ***