AnsweredAssumed Answered

Compare Date Input Control with object Ca

Question asked by RJARA82 on Apr 19, 2017
Latest reply on Apr 22, 2017 by RJARA82

Hi, I need help

I'm creating a report in Jaspersoft Studio and using SDM Datasource and of course objects layer, I create parameters like input control for Start_date and End_date all is fine but when I compare this parameters in my SQL query doesn´t found any result.


My sql query is like this:


select cr.open_date from cr

where cr.open_date between $P{Start_date} and $P{End_date}


There is no any message error only no data.


I believe that type of object cr.open_date is not a correct type for comparison, Start_date and End_date are the type java.sql.Date


Thank you.