CA Service Management

  • Private Community

  • 1.  How to use between date filter in jasper studio

    Posted Feb 19, 2019 09:48 AM

    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.



  • 2.  Re: How to use between date filter in jasper studio

    Broadcom Employee
    Posted Feb 19, 2019 04:16 PM

    Hi Siladitya,

    The format should be like this:

    WHERE <your_table.column> BETWEEN $P{start_date} AND $P{end_date}</your_table.column>


    Please reference below:

    https://community.jaspersoft.com/wiki/filtering-date-range

    https://community.jaspersoft.com/questions/1069186/how-filter-range-dates

     

    Thanks,
    Scott