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.

Outcomes