title: How to find the number of days between two dates
body: <p>I have a basic query:</p>
  
  <pre><code>SELECT dtCreated
      , bActive
      , dtLastPaymentAttempt
      , dtLastUpdated
      , dtLastVisit
  FROM Customers
  WHERE (bActive = 'true') 
      AND (dtLastUpdated &gt; CONVERT(DATETIME, '2012-01-0100:00:00', 102))
  </code></pre>
  
  <p>I want to add another column to the output... lets call it "Difference" to find out the number of days between 'dtcreated' and 'dtlastupdated'  So for example if record 1 has a dtcreated of 1/1/11 and dtlastupdated is 1/1/12 the "Difference" column would be "365".  </p>
  
  <p>Can this be accomplished in a query?</p>