title: SQL getting people within 30 days of birthday (regardless of year)
body: <p>i am trying to get all employees whose birthday is coming up, It seems what i am trying to go isn't functioning properly because the year is being considered each time.  </p>
  
  <p>so the query i got now is </p>
  
  <pre><code>SELECT   [emp].[FirstName]
          ,[emp].[LastName] 
          ,[emp].[Birthday]
  FROM [Employees] AS [emp]
  WHERE [emp].[ID] != 12
      AND [emp].[Birthday] &gt;= GETDATE() 
      AND [emp].[Birthday] &lt;= DATEADD(dd,20,GETDATE())
  </code></pre>
  
  <p>the problem is no employees birthday is in 2016. any idea how i can check this </p>