title: Date Criteria in Pass through SQL
body: <p>I have been provided the following information to place into an access pass through query to pull data from works SQL: </p>
  
  <pre><code>exec dbr_b2b_so_status_report 'N', '2017-01-16', '2017-01-23', -1
  </code></pre>
  
  <p>To avoid manually having to edit the dates on a weekly basis, I am hoping to either find a way for including GETDATE() - 7 days or somehow edit the dates in the query via a table or form in my access database. I don't have much experience with SQL, very limited and my skill in access is all picked up from google or Youtube videos, so I apologize in advance if my question seems silly. </p>