title: How to search between dates?
body: <p>iam using ms access database and i want to get data between two dates</p>
  
  <pre><code>stdate= starting date
  
  edate=end date
  </code></pre>
  
  <p>iam using the code below.</p>
  
  <pre><code>Private Sub Label3_Click()
  DataGrid1.Visible = True
  Dim stdate As Date
  Dim edate As Date
  Format = stdate("mm/dd/yyyy")
  Format = edate("mm/dd/yyyy")
  stdate = Text1.Text
  edate = Text2.Text
  
  Adodc1.RecordSource = "SELECT * FROM sales_info WHERE  date BETWEEN &amp;stdate&amp; and              &amp;edate&amp; "
  Adodc1.Refresh
  End Sub
  </code></pre>
  
  <p>errors iam getting are:</p>
  
  <pre><code>syntax error expected array(in format statement)
  
   missing operator in query expression date.
  </code></pre>
  
  <p>thanks </p>
  
  <p>plz help</p>
  
  <p>iam a beginner</p>