Hi All,

I have a form that allows the user to enter a begin date and end date.
The text boxes are formatted to mm/dd/yyyy.

I'm passing these text values to a Crystal .SQLQuery, for example
SELECT a.field, b.field2 FROM table a,table b
WHERE a.id = b.id AND
a.date >= &" text1.value &" AND a.date <= &"text2.value" &

When the query evaluates the date values it returns a datatype error. I'm not sure how to pass these date values because I'm not sure if it's an issue with Oracle or Crystal reports formatting.

Thanks and my work e-mail [email protected]