title: Would like SQL query that pulls the last 7 days of table data with ASP
body: <p>So I'm trying to pull the last seven days of table data using SQL within ASP. I think my syntax is incorrect</p>
  
  <pre><code>&lt;%  
  Set rstest = Server.CreateObject("ADODB.Recordset")
  sql = "SELECT * FROM DivisionNew where JMS_UpdateTime is between '" &amp; date &amp; "' and '" &amp; date 7  
  &amp; "'" 
  rstest.Open sql, db
  </code></pre>
  
  <p>%></p>