title: Manipulating DATEADD to display date in correct format
body: <p>I know this is properly an easy fix but it has been doing my head in all day! I have created a temporary table and I want to input the date for the first day of the previous month so I have used:</p>
  
  <pre><code>DATEADD(MONTH, DATEDIFF(MONTH, 0, GETDATE())-1, 0) as [Last Month]
  </code></pre>
  
  <p>Which is populating my table with <code>2014-12-01</code> but I want it to come out as <code>12/01/2014</code>. I have tried numerous times to make this work but I can't seem to get it to work, I tried to incorporate the <code>DATEADD</code> into the following SQL statement but couldn't get it to run!</p>
  
  <pre><code>replace(LEFT(convert(NVARCHAR, getdate(), 106),6) + '/' + RIGHT(year(convert(NVARCHAR, getdate(), 106)),2), ' ', '/') as [Last Month],
  </code></pre>
  
  <p>The Column I am trying to insert into is of type <code>DATE</code></p>