title: GETDATE last month
body: <p>I am trying to list last a website's statistics. 
  I listed Last 30 days with;</p>
  
  <pre><code>CONVERT(VARCHAR(10), S.DATEENTERED, 101) 
    BETWEEN 
      CONVERT(VARCHAR(10), GETDATE()-30, 101) 
    AND 
      CONVERT(VARCHAR(10), GETDATE(), 101) 
  </code></pre>
  
  <p>and this month with;</p>
  
  <pre><code>RIGHT(CONVERT(VARCHAR(10), S.DATEENTERED, 103), 7) = 
  RIGHT(CONVERT(VARCHAR(10), GETDATE(), 103), 7)
  </code></pre>
  
  <p>but I have no idea what query to use for last month. I tried with;</p>
  
  <pre><code>RIGHT(CONVERT(VARCHAR(10), S.DATEENTERED, 103), 7) = 
  RIGHT(CONVERT(VARCHAR(10), GETDATE()-1, 103), 7) 
  </code></pre>
  
  <p>Did not work.</p>