title: Improve query to select (birth)dates that are within x days from now (future and past)
body: <p>I have a table of users with a field <code>birthday</code>(DATE).</p>
  
  <p>Currently, I select users who's birthdays is within 7 days past or ahead of the current date like this:</p>
  
  <pre><code>SELECT * FROM users
  WHERE 
      DATE_FORMAT(birthday, '1980-%m-%d')
          BETWEEN
          DATE_FORMAT(DATE_SUB(CURRENT_DATE(), INTERVAL 7 day), '1980-%m-%d')
          AND
          DATE_FORMAT(DATE_ADD(CURRENT_DATE(), INTERVAL 7 day), '1980-%m-%d')
  </code></pre>
  
  <p>As you can see, this query is not the most streamlined, considering the comparison via the fabricated 1980- date formatting. Also, I believe this will fail to properly select birthday users around the last and first week of the year. </p>
  
  <p>While I am seeing the problems with this, I struggle to find how to approach this. What could I do to improve this query?</p>