update table set value where date is bigger than getdate() code example

Example: mssql check if date is greater than today

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