title: How to resolve SQLite SUM() between Dates using Delphi?
body: <p>i have an SQLite database with the fellowing fileds: (Fullname, Phone, StartDate, Montant) and i want to calculate the SUM of the field "Montant" who is between a range of dates like (SUM(Montant) between 01/01/2018 and 03/01/2018).</p>
  
  <p>the image bellow describe my problem:
  the SQL return a wrong result 200 but the correct is 120 for dates between 01/01/2018 and 02/01/2018.
  <a href="https://i.stack.imgur.com/nnXd7.png" rel="nofollow noreferrer">SQL return a wrong result</a></p>
  
  <p>anothe problem is when i put a StartDate bigger or after the database date, a float exception raise like in picture.
  The startdate is 06/01/2018 and the enddate is 10/01/2018.
  <a href="https://i.stack.imgur.com/CFKbf.png" rel="nofollow noreferrer">Exception of float occured here</a></p>
  
  <p>in Absolute Database return Zero and no exception, but SQLite return exception because he found empy field.</p>
  
  <p>help please.</p>