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

Mahesh Chand
12y
48.3k
0
0

Article

When you apply DataView1.RowFilter = "DateColumnName > " + DateValue, you get this error:
Cannot perform '>' operation on System.DateTime and System.Double

To use a Date value in a filter, you must use a pound "#" symbol around the date value like in the following:

dsView.RowFilter = "DateColumnName >= #" + DateTime.Today + "#";

DataView
DataView Rowfilter
Date
filter a date

Mindcracker

Founded in 2003, Mindcracker is the authority in custom software development and innovation. We put best practices into action. We deliver solutions based on consumer and industry analysis.