i am using two date parameters $P{StartDate} AND $P{EndDate} and having a query like SELECT DISTINCT expirydate.`ArticleName` AS expirydate_ArticleName, medicinelist.`Pos` AS medicinelist_Pos, medicinelist.`Quantity` AS medicinelist_Quantity, expirydate.`ExpirationDate` AS expirydate_ExpirationDateFROM `expirydate` expirydate INNER JOIN `medicinelist` medicinelist ON expirydate.`Barcode` = medicinelist.`Barcode`WHERE expirydate_ExpirationDate BETWEEN $P{start_date} AND $P{end_date}order by medicinelist_Pos it showing error"Parameter type not supported in query : start_date class net.sf.jasperreports.types.date.DateRange". How can i fix the issue???
