title: Compare dd-mm-yyyy datetime
body: <h2>Problem</h2>
  
  <p>I want to compare "dd-mm-yyyy" DateTime's without factoring in the time.
  <br></p>
  
  <h2>Attempt</h2>
  
  <p>I have tried comparing the standard DateTime values with my database DateTime's like this: </p>
  
  <p><strong>C#/LINQ:</strong></p>
  
  <pre><code> var startDate = DateTime.Today.AddDays(-10);
   var endDate = DateTime.Today;     
       dateList= (from x in db.MY_DB
           where (x.DATE &gt;= startDate &amp;&amp; x.DATE &lt; endDate)   
           select x).ToList();
  </code></pre>
  
  <p>However, my list never gets populated, even though many entries meet this criteria, which I verified with the following query in SQL: </p>
  
  <p><strong>SQL Query:</strong></p>
  
  <pre><code>Select * from db.my_db where date between '13-JUN-2016' and '23-JUN-2016';
  </code></pre>