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 + "#";
Vishal GilbilePosted Mar 1, 2013, 4:35 AM
Mahesh its good tip by why should i use #. I mean what the reason for using it.
wws35801editedPosted Mar 21, 2007, 10:59 PMEdited Mar 21, 2007, 11:00 PM
I get the following error 'System.DateTime.Today' is a 'property' but is used like a 'method' When I use the following Filter: bsvUnion_TSeries_TGrp_Test.Filter = "FDate > #" + 12/01/2006 +"# and FDate <= #" + DateTime.Today() + "#"; Any help will be greatly appreciated.
Moses SolimanPosted Feb 22, 2007, 1:35 PM
Thank for the tip Mahesh