title: SQL - get last month data
body: <p>I have been using this query to extract information from last month</p>
  
  <pre><code>SELECT * 
  FROM Member
  WHERE DATEPART(m, date_created) = DATEPART(m, DATEADD(m, -1, getdate()))
  </code></pre>
  
  <p>with the end of the year approaching, will this automatically pull Dec 2012 when i run it in Jan 2013 ?</p>