check end date greater than current sql server code example

Example: mssql check if date is greater than today

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