General information
Category:
Coding, syntax & commands
>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
Previous
Next
Reply
View the map of this thread
View the map of this thread starting from this message only
View all messages of this thread
View all messages of this thread starting from this message only