title: Using a between Date in SQL QUERY
body: <p>Im using vb.net code with Sql Server 2008 R2.<br>
  I'm trying to get result by using a SQL query to get all rows that have a value between 2 dates:
  Here is my the <code>where</code> clause of my statement:</p>
  
  <pre><code>Where (CONVERT(varchar(10), visit_nextVisitDate, 103) between '02/04/2017' AND  '15/05/2017')"
  </code></pre>
  
  <p>but I always get all rows for the same month (month 4).
  I tried this:</p>
  
  <p><code>WHERE (CAST(dbo.Visits.visit_date AS date) BETWEEN '24/04/2017' AND '02/05/2017')</code> </p>
  
  <p>but I got an error cause my date fields are saved in format <code>yyyy/mm/dd</code></p>
  
  <p>How can I change the SQL date format to <code>dd/mm/yyyy</code>?  </p>