title: SQL Server - Deleting rows between a date range using SQL. Date conversion fails
body: <pre><code>DELETE FROM BIZ 
  WHERE [Orgnl_Cmpltn_Date]
        BETWEEN '2014-02-31'  AND '2014-04-01'
  </code></pre>
  
  <p>This is the <code>DELETE</code> statement I wrote. There is an error that says: </p>
  
  <blockquote>
    <p>Conversion failed when converting date and/or time from character string.</p>
  </blockquote>
  
  <p>I know I have to write the correct date format, but I am not sure how that goes. </p>
  
  <p>This question has not been answered elsewhere because the answers I saw did not specify date format (in the context that I am asking for)</p>