title: Compare two dates inside the where clause
body: <p>I got an error on Where clause "X" when execute this query</p>
  
  <pre><code>select top 100 DATEADD(HOUR,10, DateCreated) as X
  from y
  where X between '2015 -03-31 ' and '2015 -04 -02' 
  order by DateCreated desc
  </code></pre>