title: c# datatable select statement with dates
body: <p>i am trying to make a select statement on a datatable to get the row that is within the date range i am looking for. I am new to this an i dont quite understand how this select statement works. I tried to write this but is not working. Can you please give me a hand here. I am stuck</p>
  
  <pre><code>foundRows = dt.Select("DATE1 &lt;= '" + date1+ "' AND DATE2 &gt;= '" + date1+ '"');
  </code></pre>