Thanks, kaushiklokesh123 and hozawa, I succeeded and I understood what was wrong. My query looks like this: SELECT fields FROM table_name WHERE field_date LIKE '$ P! {Date} '// DATE is a java.lang.String parameter and change the equals (=) by LIKE, and add the apostrophes ( ' ' ) and it worked!!!! The fields in the band details also change them but does the same as java.lang.String as java.util.Date. It works, thank you.
I also tested with BETWEEN thus leaving my query: SELECT fields FROM table_name WHERE field_date BETWEEN $ P {Start_Date} AND $ P {End_Date} Where $ P {Start_Date} and $ P {End_Date} are of type java.util.Date both. I also work. Thank you.
Another question is: what is the difference between: $ P {} and $ P! {}, (exclamation mark). First of all, Thanks.
