You can change string dates to date constant.

clist1 = "{^2003/06/01}"     && "06/01/03"
clist2 = "{^2003/06/20}"     &&"06/20/03"

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

>clist1 = "06/01/03"
>clist2 = "06/20/03"
>
>cWhere = " AND (docdate" + [ >= ] + clist1 + [ AND ] + " docdate" + [ <= ] + clist2 + ")"