DateTime filtering in DataTable.DefaultView.RowFilter

Question

I have tried to filter the DateTime column from a DataTable using RowFilter and the column contains the Date with the Time.

I have tried like below,

dataView.RowFilter = "[Date] = #6/26/2011 2:53:24 PM#";

But the filter is not working.

Could anyone please update me the proper filter string to filter the date column in DataTable ?

_Date values should be enclosed within pound signs (#) or single quotes (') based on the data provider_ — Steve, Jun 26 '18 at 06:20
@Steve - I have tried giving pound signs and single quotes also, but the filter is not working properly. — Amal, Jun 26 '18 at 06:26
What do you mean by _not working_ exactly by the way? Is this filter works on your database engine itself? Are you _really_ sure about the format part? — Soner Gönül, Jun 26 '18 at 06:50
@SonerGönül - I am just using DataTable in winforms application. — Amal, Jun 26 '18 at 08:40
@SonerGönül - Refer this thread for clear understanding about exact case - https://stackoverflow.com/questions/51042097/filtering-in-datatable-is-not-working-for-datetime-now-or-datetime-adddays — Amal, Jun 26 '18 at 11:50

User0804 · Answer 1 · 2018-06-26T07:15:45.777

0

You can use this code:

  string str =  "YourDateTime";

  string dtFilter = string.Format("[Date] = '{0} '", str);
  (dataGridView1.DataSource as DataTable).DefaultView.RowFilter = dtFilter;

edited Jun 26 '18 at 07:15

answered Jun 26 '18 at 07:06

User0804

77
2
12

I have updated the question with Data image and the filter text. Its not working. – Amal Jun 26 '18 at 09:24

gridtrak · Answer 2 · 2020-05-18T22:24:58.930

0

Use the CONVERT(expression, type) syntax to convert you text to a RowFilter DateTime.

For example:

dataView.RowFilter = "[Date] = CONVERT('6/26/2011 2:53:24 PM', 'System.DateTime')";

Reference: DataView.RowFilter Property

Reference: CONVERT function in DataColumn.Expression Property

edited May 18 '20 at 22:24

answered May 18 '20 at 21:48

gridtrak

731
7
20

score 0 · Answer 3 · answered Aug 28 '20 at 23:28

0

Dim strFilter As String = "MovDay >= '" & dteInitial.ToShortDateString & "'" & " AND " & "MovDay <= '" & dteFin.ToShortDateString & "'"

dSetNewMov.Tables(0).DefaultView.RowFilter = strFilter

answered Aug 28 '20 at 23:28

Robert

1

DateTime filtering in DataTable.DefaultView.RowFilter

3 Answers3