tsql check if start date is greater than end date code example Example: mssql check if date is greater than today WHERE YourDateValue >= DATEADD(MONTH, 1, GETDATE())