Cannot perform '>' operation on System.String and System.DateTime

Question

I'm trying to filter my DataView by date:

DataTable dt = GetTableData();
DataView dvEvents = dt.DefaultView;
dvEvents.RowFilter = "date > #" + DateTime.Now.ToString() + "#";

But I'm getting this error:

Cannot perform '>' operation on System.String and System.DateTime.

I've also tried DateTime.Now.ToString("MM/dd/yyyy"), and I get the same error.

What am I doing wrong here?

Answer 1

If you are using string values you need to replace the # with '.

For example:

dvEvents.RowFilter = "date > '" + DateTime.Now.ToString() + "'";

See this reference