Date condition in SQL statement

[lindaklu]

Hello,

I am using Progress 9.1C Database and Merant 3.60 Progress SQL92 for my ASP Pages.

I am trying to issue a select statement with a Date condition:

CustNum=Request.QueryString("custnum_form")
mydate=Request.QueryString("date_form")
...
...
str="SELECT * FROM pennaux Where (update\-on=' " & mydate & " ') and (cust='" & CustNum & "') "

But I get this error " Incompatible data types in expression or assignment. (223)"

Is there a problem with my sql statement? Should there be a different way to put a date as a search criteria?

Thanks in advance.