title: date is incompatible with int
body: <p>I get this error and although i tried to search for an existing answer, i could not implement is in mt query</p>
  
  <p>so i have got :</p>
  
  <blockquote>
    <p>Msg 206, Level 16, State 2, Line 3
    Operand type clash: date is incompatible with int</p>
  </blockquote>
  
  <p>This is my query :</p>
  
  <pre><code>Select   emp_desc, SUM(Price*Num_Of_Products) 
  from     sales
  Where    sale_date between 2014-01-01 and 2017-01-01
  GRoup By emp_desc
  </code></pre>
  
  <p>any suggestions?
  Many Thanks</p>