title: Calculating date difference in SQL query
body: <p>I need to calculate date difference using flowing query but it does not work.  Please advise.</p>
  
  <pre><code>SELECT ID, VoucherNo, DateRec, ProductID, Description, ClaimantCo, ClaimantName, City, Phone, DateReturn, ReqJob, WSIns, Remarks, Status, Part1, Part2, Part3, Part4, OtherWSCharges, FDCharges, P1Charges, P2Charges, P3Charges, P4Charges, DateJobBegun, DateJobDone, WSRemarks, TotChargesFromWS, DeliveryStatus, DateDelivered 
  FROM tblClaims 
  WHERE DateDiff(dd, DateReturn, GETDATE()) =3
  </code></pre>
  
  <p>My purpose is to get records for which three days are left to DateRetun, comparing to today's date.</p>
  
  <p>Thanks</p>