title: Query to get Data by Date of different Fields
body: <p>I want to get data from a database using compare date(income,outcome date and another field) I'm using this format:</p>
  
  <pre><code>Form6.ADOTable1.Filter := 'student_name like '+QuotedStr(sEdit1.Text) +
         ' and income_date  &gt;='''+date1+''' and income_date  &lt;= '''+date2+'''+
         ' and outcome_date &gt;='''+date1+''' and outcome_date &lt;= '''+date2+'''';
  </code></pre>
  
  <p>when I run the program I get an error, I don't know why. Please help me.
  <strong>I am using Delphi 7</strong> </p>