>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
>

Jim;

One more suggestion:

As an example if you are using the SqlDataAdapter try:

SqlDataAdapter1.SelectCommand.CommandText = “your select statement goes here”

This should be faster than using the RowFilter.


Tom