mssql check if date is greater than today
snippet in sql

mssql check if date is greater than today

user6424

WHERE YourDateValue >= DATEADD(MONTH, 1, GETDATE())