title: how to search using BETWEEN in sql
body: <p>how to search using <strong>Between</strong> in <strong>mysql</strong> in <strong>vb.net</strong>?</p>
  
  <p>i tried some codes but its not working.</p>
  
  <p>here is the sample database: </p>
  
  <pre><code> ___________________________
  |            date           |
  -----------------------------
  |Wednesday, December 4, 2013|
  -----------------------------
  
  here is my code in vb.net:
  
  Dim sqlquery As String = "SELECT * FROM complaint WHERE date BETWEEN '" &amp; dtepicker1.text &amp; "' and '" &amp; dtepicker2.text &amp; "'"
  
  Dim sqlcmd As New MySqlCommand
  
  With sqlcmd
      .CommandText = sqlquery
      .Connection = connectionsrvr
  End With
  </code></pre>