title: Simple Query error message Msg 241, Level 16, State 1, Line 1 Conversion failed when converting date and/or time from character string
body: <p>I am using MSSQL and I get the aforementioned error message when I try to execute the following query. </p>
  
  <pre><code>Select * 
  from fa_disp
  where dispdt between '2014-10-01' and '2015-09-31'; 
  </code></pre>
  
  <p>I know there is a simple answer.  When I look at all of the other questions and answers for this error msg they are so complex and involved.  I am new to this so when I tried the examples it still didn't work.  Help please? </p>