title: SQL Server: How to get rows where the date is older than X years?
body: <h2>Question</h2>
  
  <p>I would like to pull all assets from a database which is a certain amount of years old, in this case years. Is this statement correct?</p>
  
  <h2>Background</h2>
  
  <p>The database is called <code>AssetRegister</code></p>
  
  <p>The table is called <code>dbo.Assets</code></p>
  
  <p>the column is called <code>AcquiredDate</code></p>
  
  <h2>Statement so far</h2>
  
  <pre><code>SELECT * FROM dbo.Assets WHERE AcquiredDate &lt; '2008-01-01'
  </code></pre>