WHERE
Docket_Date >= DATEADD(MONTH, DATEDIFF(MONTH, 0, @date1), 0) AND
Docket_Date < DATEADD(MONTH, DATEDIFF(MONTH, 0, @date1) + 1, 0)
SQL DBA,SQL Server MVP(07, 08, 09) "Money can't buy you happiness." Maybe so, but it can make your unhappiness a LOT more comfortable!