title: linq where clause with 2 datetime conditions
body: <p>I have a Where clause that looks like this:</p>
  
  <pre><code>where p.Appoint.Date &gt; TheStartTime.Date &amp;&amp; p.Appoint.Date &lt; TheEndTime.Date
  </code></pre>
  
  <p>For some reason, it's returning 0. However, if I write this</p>
  
  <pre><code>where p.Appoint.Date == TheStartTime.Date
  </code></pre>
  
  <p>it returns a count (not the one I want though). What am I doing wrong?</p>
  
  <p>Thanks for your suggestions.</p>