title: DataTable select method with Dates not showing right result
body: <p>I have a Datatable with rows that i need to remove and insert into another Datatable. I am selecting the rows where column SLA &lt; than todays date (SLA &lt; '#date#'). When i do this the data in my new Datatable is not correct. I am getting rows that have dates that are later than todays date. I dont know what i am dowing wrong. The SLA column date syntax is <strong>dd-MM-yyyy HH:mm</strong>. </p>
  
  <p>Here is my code:</p>
  
  <pre><code>public SLAWarningHandler()
  {
  }
  public DataTable SLAWarningData(DataTable queryData)
  {
      DataTable data = queryData;
      try
      {
          DateTime date = DateTime.Now;
          DataRow[] rows = data.Select("SLA &lt; '#" + date + "#'");
          DataTable actual = new DataTable();
          actual = data.Clone();
          foreach (DataRow row in rows)
          {
              actual.ImportRow(row);
          }
      }
      catch (Exception exception)
      {
          throw exception;
      }
      return data;
  }
  </code></pre>
  
  <p>I have tried to convert the date parameter to a string like so:</p>
  
  <pre><code>date.ToString("dd-MM-yyyy HH:mm")
  </code></pre>
  
  <p>but that didnt help.</p>
  
  <p>Can anyone point out my issue?</p>
  
  <p>thanks! </p>