All,
I have a windows application which allows the user to search data by date range like Quicken(today, this week, this month, etc) The form has a grid on it that displays a dataview. I want to filter the data by the date range, but am getting an error message. The error is expression contains unsupported operator 'between'. Is there a different way to set the filter? The current code is below.
dvdata.rowfilter = "calldate Between " + cboStart.Value.Date + " and " + cboEnd.Value.Date
Thanks
Jim