Input Control Date not working properly

[blenheimfire]

I'm running Jasper Report Server 6.10

I setup input control date for a report the report  will alway return blank when attempting to sort by date range.

I've ensured the parameters match the ID of input control exactly. 

If I manually put the dates into query it returns successfully. I'm not sure what i'm missing. 

Please help if you can.

 

[arnaudsimon091]

Hi blenheimfire ! 

I have faced this problem too, you need to change your "AND" statement in your query.

Instead of : 

AND p.RegistrationDate BETWEEN $P{StartDate} AND $P{EndDate}

use : 

AND $X{[bETWEEN], p.RegistrationDate, StartDate, EndDate}

Try to check this doc to have a better understanding of this syntax : https://community.jaspersoft.com/documentation/tibco-jasperreports-server-administrator-guide/v60/cascading-input-controls

Best regards.