>Can you please tell me how i can use the below date range condition in the where clause.
>
>i am trying to join the cwhere condition to my existing where statement.
>
>I am getting an error saying operator or operand mismatch type...
>

The problem, I think, is that you're putting in character dates without anything to indicate they're dates. Besides that, you may want to use BETWEEN. How about:

cWhere = " AND BETWEEN(docdate,{" + clist1 + "}, {" + clist + "})"

Tamar