title: Date Diff Between two Columns
body: <p>Please can you help with the following query regarding the Difference between two dates.</p>
  
  <p>My current table is combined with plenty of columns, however I would like to add another column to identify the date difference.</p>
  
  <p>Two of the columns within the table should be compared and the date diff must then populate in the new added column, however no hours, seconds, mill seconds should be taken into account. The query should only count the different date changes.</p>
  
  <p>Columns </p>
  
  <pre><code>- ServiceDt    (2014/09/22)
  - ServiceToDt
  - SettleDt
  - ReceiveDt
  - AssessDt     (2014/10/01)
  
  - New Column   ( 9 Days) 
  </code></pre>
  
  <p>The <code>New Column</code> must be updated with the Difference between the <code>ServiceDt</code> and <code>AssessDt</code>.</p>
  
  <p>The date diff should be counted as 9 days, as 9 different time dates occurred. </p>
  
  <p>Hope any of the above makes sense. I have tried so many queries and cant give you even one example as non of them worked. </p>
  
  <p>Thank you. </p>