title: SQL Server - Select between 2 dates of type DD/MM/YYYY
body: <p>I want to query a datetime field using a range of dates provided in the format DD/MM/YYYY.  </p>
  
  <p>I know that to convert datetime to a DD/MM/YYYY format that I can use:</p>
  
  <pre><code>CONVERT(CARCHAR(10), ORDERDATE,103)`
  </code></pre>
  
  <p>And this works fine when querying a single date, eg:</p>
  
  <pre><code>SELECT DISTINCT 
  CONVERT(DATE, ORDERDATE),
  CONVERT(CARCHAR(10), ORDERDATE,103)
  FROM ORDERS
  WHERE CONVERT(CARCHAR(10), ORDERDATE,103) = '19/10/2017'
  </code></pre>
  
  <p>Returns: <code>2017-10-19, 19/10/2017</code></p>
  
  <p>However it does not work on a <strong>range</strong> of dates, eg:</p>
  
  <pre><code>WHERE CONVERT(CARCHAR(10), ORDERDATE,103) BETWEEN '17/10/2017' AND '19/10/2017'
  </code></pre>
  
  <p>Returns:</p>
  
  <pre><code>2014-02-05
  2016-12-12
  2013-04-30
  </code></pre>
  
  <p>I know there are hundreds of threads about SQL dates, but they all seem to be regarding reformatting the output and not preparing the input.  Do I need to reformat my DD/MM/YYYY inputs?  </p>