Cacher is the code snippet organizer for pro developers

Select *
FROM Employees
Where DATEDIFF(MONTH, HireDate, GETDATE()) Between 1 and N


DATEDIFF(datepart,startdate,enddate)

DAY()
MONTH()
YEAR()