title: Select all records 'younger' than 7 days
body: <p>I want to select all the records from <code>[Orders]</code> that have a <code>[Submissiondate]</code> less than 7 days.</p>
  
  <p>I'm completely stumped. This is the query I'm executing:</p>
  
  <pre><code>SELECT * FROM [Orders] WHERE ([SubmissionDate] &lt; @SubmissionDate)
  </code></pre>
  
  <p>Doesn't work.</p>