title: How do I select records less than 1 year old?
body: <p>This should be a fairly simple question but I know very little about SQL. I have a database which has the following fields:</p>
  
  <ul>
  <li><code>client_id</code></li>
  <li><code>scheduled_amount</code></li>
  <li><code>deposit_amount</code></li>
  <li><code>message_code_id</code></li>
  <li><code>note_text</code></li>
  <li><code>system_date</code></li>
  </ul>
  
  <p>Now I wish to select all the records that are less than 1 year old from when the SQL statement is run. I know I should use <code>DateDiff</code>, anyone got any ideas?</p>
  
  <p>Thanks</p>