title: Return all Data excluding current month
body: <p>I wish to retrieve all data, though I wish to exclude the current month.</p>
  
  <p>The where statement that I'm using is</p>
  
  <pre><code>and MONTH(MOPEFD) &lt;= MONTH(DATEADD(month, - 1, GETDATE()))) 
  </code></pre>
  
  <p>When I run it in Feb, I only get data for Jan 2020, Jan 2019, Jan 2018, Jan 2017.</p>
  
  <p>I wish to get data for Jan 2020, Dec 2019, Nov 2018...... to the start.</p>
  
  <p>Next month I will wish to get Feb 2020, Jan 2020..... to the start.</p>