title: add +- 1 year in SQL Server
body: <p>I try to select the Products that has a yearmodel between +1 and -1 the current year. And I only want the Year (ex 2011) not the full date and time.</p>
  
  <pre><code>SELECT ProductName FROM tblProduct WHERE Year BETWEEN 
  year(getdate()+1) AND year(getdate()-1)
  </code></pre>
  
  <p>Does not work, but something similar maybe...</p>