check if one date is greater than another sql code example
Example 1: query less than datetime sql
select *
from dbo.March2010 A
where A.Date >= '2010-04-01'
Example 2: mssql check if date is greater than today
WHERE YourDateValue >= DATEADD(MONTH, 1, GETDATE())