>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 + ")"
>
>
>*****************************************
>
>
>Thank you very much.
clist1 = '^2003/06/01' && Or was it Jan 6 ?
clist2 = '^2003/06/20'
cWhere = ' and docdate Between ctod(clist1) and ctod(clist2) '
Cetin