Error messages

Mr Duncan

Hi Folks - Urgent help needed here - Am I missing something ?

I have checked the report and query parameters and they are identical. At one point they were different .

Do I have a cache problem ?

ERROR MESSAGE BELOW :

Table (id = 1029):
+ An exception occurred during processing. Please see the following message for details:
Failed to prepare the query execution for the data set: Parts_not_in_stock
Cannot set the date value (2012-03-01 00:00) to parameter 2.
Cannot set preparedStatement parameter date value.
SQL error #1: Invalid parameter index 2.

RichT

Hi,

What is the Data type (and other details) for parameter_2 and how are you setting the parameter?

Rich