Crystal Reports sub report issue

Dear Experts,


I have a report with a date parameter

it passes it to the subreport


subreport has a query with a parameter


the query is



 select distinct invntryitm_id,serial,itemdesc  from (
SELECT DISTINCT ABCOSPRO_EQTOOL.invntryitm_id, ABCOSPRO_EQTOOL.serial, ABCOSPRO_EQTOOL.itemdesc, ABCO_Inv_batch.date,case when ABCO_Inv_batch.date is null then '' else ABCO_Inv_batch.date end as thedate
FROM         ABCO_Inv_data INNER JOIN
                      ABCO_Inv_batch ON ABCO_Inv_data.batch_rn = ABCO_Inv_batch.batch_rn FULL OUTER JOIN
                      ABCOSPRO_EQTOOL ON ABCO_Inv_data.serial = ABCOSPRO_EQTOOL.serial
WHERE     (ABCOSPRO_EQTOOL.serial LIKE '%') AND (ABCOSPRO_EQTOOL.serial <> ''))x
where thedate not in  ({?Pm-@qdate} )
and serial not in (
SELECT DISTINCT ABCOSPRO_EQTOOL.serial
FROM         ABCO_Inv_data INNER JOIN
                      ABCO_Inv_batch ON ABCO_Inv_data.batch_rn = ABCO_Inv_batch.batch_rn FULL OUTER JOIN
                      ABCOSPRO_EQTOOL ON ABCO_Inv_data.serial = ABCOSPRO_EQTOOL.serial
WHERE     (ABCOSPRO_EQTOOL.serial LIKE '%') AND (ABCOSPRO_EQTOOL.serial <> '') and convert(varchar(50),date) =  ({?Pm-@qdate} ))








-------------
for some reason if I enter the date 3/19/2012 the main report takes it but the subreports sees 04/12/3765 or something





someone please help

Thanks in advance