//Define my variables to be used in the search. these are my 2 DateTimePickers. I have tried leaving off the "ToString()" method and leaving the variables as DateTime, also with no luck string begin = dateTimeLater.Value.ToString("M/dd/yyyy 00:00"); string end = dateTimeEarlier.Value.ToString("M/dd/yyyy 23:59"); // At this point I have used a Messagebox to display the values of begin and end. They are correct. //Create my dataview - this also works fine. DataView gridView = new DataView(reserveTrackerDataSet.Tables["Authorizations"]); //Try and filter gridview - THIS RETURNS NO MATCHES. I have verified that there is data in the dataset that DOES match the filter criteria, yet nothing is returned. FYI - Date is of type DateTime in the dataset. gridView.RowFilter = "Date IN (#" + begin + "#, #" + end + "#)"; //I have also hardcoded the date values directly in my RowFilter statement to determine if my variables were the problem like below, but still NO MATCHES even thou data in the dataset should match. gridView.RowFilter = "Date IN (#1/01/2009 00:00#, #2/16/2009 23:59#)";
Take hold of your future.