title: How to filter by a date range without time components in an SQL statement
body: <p>Example query</p>
  
  <pre><code>SELECT * FROM orders WHERE New_ActualDate &gt;= @fromdate AND New_ActualDate &lt;= @todate
  
  q.Parameters.AddWithValue("@fromdate", calFrom.SelectedDate);
  q.Parameters.AddWithValue("@todate", calTo.SelectedDate);
  </code></pre>
  
  <p>When I examine the parameter values they are:</p>
  
  <p>@fromdate = '01/08/2016 00:00:00'
  @todate = '31/08/2016 00:00:00'</p>
  
  <p>The issue i'm seeing is that any orders from yesterday (31st August) are missing from the report.</p>
  
  <p>Do I need to also set the time in this example?</p>