select * from table where datepart(yyyy, salesdate) = 2004 and datepart(mm, salesdate) = 12>Can someone please help me, I have some records with date field type, what I want to ask is simple: how to filter those records by month and year .. (ie. I want to show sales records with the following criteria: