title: Set Static Day and Previous Month GETDATE() SQL
body: <p>The following SQL statement sets the date for a particular column:</p>
  
  <pre><code>DATEDUE=convert(varchar,GETDATE(),103 )
  </code></pre>
  
  <p>However, its sets the current date such as  05/08/2015. What I wish to do is to have it in the same <strong>dd/mm/yyyy</strong> format but to set the day to the 15th and the month to the previous month, so <strong>05/08/2015</strong> should be <strong>15/07/2015</strong> instead. </p>