title: Datatable select greater than date
body: <p>I have populated a datatable with MySQL data, and I need to retrieve all records from the datatable where "unitassign" is DBNull AND the "putime"(MySQL datetime format) is greater than or equal to today's date (even if the time already passed) AND the "putime"(same variable) is less than or equal to a vbdatetime variable "eighthr" (this one would be matching based off date and time)</p>
  
  <pre><code>Dim eighthr As DateTime
  If (DateTime.Now.AddHours(8).ToString("yyyy-MM-dd") = Date.Now.ToString("yyyy-MM-dd")) Then
      eighthr = CDate(DateTime.Now.ToString("yyyy-MM-dd"))
  Else
      eighthr = DateTime.Now.AddHours(8)
  End If
  resultstr = "unitassign is Null AND (putime &gt;= #" &amp; SchedulerControl1.Start.ToString("yyyy-MM-dd") &amp; "# AND putime &lt;= #" &amp; eighthr &amp; "#)"
  
  Dim result() As DataRow = jboardtable.Select(resultstr)
  </code></pre>
  
  <p>this is returning no results although I do have rows in my datatable that should be appearing</p>