AnsweredAssumed Answered

How to use between date filter in jasper studio

Question asked by SiladityaDhar on Feb 19, 2019
Latest reply on Feb 19, 2019 by johsc03

i used below code but it not working

 

SELECT
chg.chg_ref_num,
chg.category_symbol,
chg.open_date,
chg.status_symbol,
chg.close_date,
chg.summary
FROM
chg
WHERE
chg.open_date BETWEEN 2011-12-01 00:00:00 AND 2011-12-30 00:00:00

 

Please help me.

Outcomes