title: DataGridView RowFilter By Date
body: <p>My <code>dataGridView_flaggedComments</code> has, let say, 10 rows. Value in the <code>Comments_Date</code> column's cell shows dates in the format of <code>31/12/2014 12:01 PM</code>, if I choose a date (which is without time portion) from <code>comboBox_stockDates</code> (e.g. 31/12/2014), I want it to filter (and display) all the rows that have <code>31/12/2014 xx:xx xx</code>.</p>
  
  <p>The below code would yield zero result even when the selected date (e.g. 31/12/2014) matches the rows which contain <code>31/12/2014 xx:xx xx</code>. Any idea what has gone wrong here?</p>
  
  <pre><code>string dtFilter = string.Format("Comments_Date = #{0}#", comboBox_stockDates.SelectedItem.ToString());
  (dataGridView_flaggedComments.DataSource as DataTable).DefaultView.RowFilter = dtFilter;
  </code></pre>
  
  <p>Alternatively, is there a way to convert both dates to string then compare? I tried to use LIKE operator but error says cannot be used to compare between DateTime and String.</p>
  
  <p>Any help and guidance would be much appreciated! Thank you. :)</p>