title: How to select data that is older than 12 months?
body: <p>I have a table as follows;</p>
  
  <pre><code>caravan_id, description, date_purchased, special_instructions, health&amp;safety_check, notes
  </code></pre>
  
  <p><code>health&amp;safety_check</code> is a date field.</p>
  
  <p>How can I perform an SQL query for data in this table that returns all rows which have a <code>health&amp;safety_check</code> older than 12 months. But if possible one that is based on 12 months, not on today's date such as &lt; 10/12/2011</p>