title: Query to get items due in the next 7 days
body: <p>I have an <code>insurance_end</code> column in my table, which is a <code>datetime</code> value.</p>
  
  <p>So with today's date being: <code>2015-02-20</code>, I want to retrieve items that are due to end in the next 7 days.</p>
  
  <p><strong>Sample Data:</strong></p>
  
  <pre><code>insurance_end
  =======================
  2017-02-13 00:00:00.000
  2016-02-13 00:00:00.000
  2015-02-13 00:00:00.000
  2015-02-14 00:00:00.000
  2015-02-20 00:00:00.000
  2015-02-28 00:00:00.000
  2015-02-28 00:00:00.000
  2015-02-04 00:00:00.000
  2015-02-13 00:00:00.000
  2015-02-01 00:00:00.000
  2015-02-10 00:00:00.000
  2013-02-09 00:00:00.000
  </code></pre>
  
  <p><strong>Desired output would be:</strong></p>
  
  <pre><code>insurance_end
  =======================    
  2015-02-14 00:00:00.000
  2015-02-20 00:00:00.000
  2015-02-13 00:00:00.000
  </code></pre>
  
  <p>Here's what I tried:</p>
  
  <pre><code>SELECT* 
  FROM customer_profile
  WHERE DATEADD(dd, -7, insurance_end) &lt;= CAST(insurance_end AS DATETIME)
  </code></pre>