title: Filtering by date and time C#
body: <p>I'm creating reports in C# ASP.Net, whereby in the reports I can filter data created between two different dates (e.g Start date: 15th July and End date: 17th July) but when it comes to filtering data created on a particular day (e.g StartDate: 15th July and End Date: 15th July) the query doesn't retrieve anything...</p>
  
  <pre><code>//Code from OutletDistributor.aspx.cs
  ReportManager master = ObjectFactory.GetInstance&lt;ReportManager&gt;();
  ReportResponse responce = new ReportResponse();
  if (ddDistributor == Guid.Empty)
    responce = master.GetAllOutletDistributor(sDate, EDate);
  else
    responce = master.GetOutletDistributor(sDate, EDate, ddDistributor);
  ReportViewer1.Reset();
  ReportViewer1.LocalReport.DataSources.Clear();
  ReportViewer1.ProcessingMode = ProcessingMode.Local;
  var stream = Assembly.GetAssembly(typeof(SampleReport)).GetManifestResourceStream(responce.ReportResource);
  ReportDataSource reportDataSource = new ReportDataSource(responce.ReportDataSet, responce.ReportDataSource);
  stream = RdlcReportHelper.TranslateReport(stream);
  ReportViewer1.LocalReport.DataSources.Add(reportDataSource);
  ReportViewer1.LocalReport.LoadReportDefinition(stream);
  ReportViewer1.LocalReport.DisplayName = ResourceHelper.GetText(null, "hq.rpt.outletdist.heading");
  ReportViewer1.LocalReport.Refresh();
  
  //Code from ReportManager.cs
  //Filter All Outlet Distributor
  public ReportResponse GetAllOutletDistributor(DateTime StartDate, DateTime EndDate) {
    ReportResponse report = new ReportResponse();
    report.ReportResource = "Distributr.HQ.Lib.Reports.RcdlFiles.OutletDistributor.rdlc";
    List&lt;OutletReportItem&gt; Report = _outletReport.GetAllOutlets()
      .Where(p =&gt; p.CreationDate &gt;= StartDate &amp;&amp; p.CreationDate &lt;= EndDate).ToList();
    Report.ForEach(n =&gt; report.ReportDataSource.Add(n));
    report.ReportDataSet = "dsOutletDistributor";
    return report;
  }
  </code></pre>