Hi,

I am trying to integrate crystal reports with a J2EE project. I have a table which has a column "ORDER_DATE" with datatype - DATE. i am trying to get this column using "so.order_date between to_date('{?FromDate}','MM/DD/YYYY') and to_date('{?ToDate}','MM/DD/YYYY')". I pass the dates from my code in this very format "02/03/2009". But when i run the report, I get  the error:

com.crystaldecisions.sdk.occa.report.lib.ReportSDKException: JDBC Error: ORA-01858: a non-numeric character was found where a numeric was expected ---- Error code:-2147467259 Error code name:failed

I have tried removing the date conditions and it seems to work fine without it. I read a lot of forums and they all say that there is something wrong with the date format. Please help with this....