DECLARE @StartDate datetime, @Enddate datetime
SET @StartDate = CAST(@year*10000 + @month*100 + 01 AS char(8)) 
SET @Enddate = DATEADD(mm, 01, @StartDate)
...
  WHERE mydatefield >= @StartDate AND mydatefield < @Enddate
...

>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:
>
>date field is salesdate
>
>month = 12
>year = 2004
>