Can not convert the value of 07/242008 12:00:00:000 AM to Datatype.

bmil

Hi!

Data source is Oracle 10g DB. My data set is:

select t.* from dk_all_dw t
where dat_preseka=?
and vp_koda='KBMR'
and stev_vp> 10000

1) When I set up input parameter type to DateTime in DataSet parameter form, I've got following errors:Can not convert the value of 07/24/2008 12:00:00:000 AM to Datatype.

2) If I set up the input parameter type to Date in base DataSet parameter form and everything is OK. In report parameter date parameter is DateTime type.

3) If data source is mysql everything is OK.


Thanks

Boris




data set for date parameter:

select distinct dat_preseka dat_preseka
from dk_all_dw

report parameter:

dat_preseka is set to DateTime type.

birtq

Hi

You can use something like this :

enteredDate = params["ReportDate"];
temparray = enteredDate.split('/');
enteredMonth = temparray[0];
enteredDay = temparray[1];
enteredYear = temparray[2];
enteredDate = enteredYear + "-" + enteredMonth + "-" + enteredDay;
this.queryText = this.queryText + " and Date >= " + "'" + enteredDate + "'";

Regards,
birtq