title: GETDATE -1 or 2
body: <p>With this:</p>
  
  <pre><code>CONVERT(varchar(10),DATEADD(month,1,GETDATE()),120)
  </code></pre>
  
  <p>I get this</p>
  
  <pre><code>2013-08-19
  </code></pre>
  
  <p>which is perfect but I need it to output one or two days less</p>
  
  <p>example: <code>2013-08-18</code></p>
  
  <p>Any tips?</p>