CA Service Management

 View Only

Age of ticket in jasper report

  • 1.  Age of ticket in jasper report

    Posted May 23, 2019 06:40 AM



    I have SDM 17.1 with Jasper report 6.4.3


    I use default SDM_DS data source in Jasper report to create reports. i created domain, adhoc view and table report for daily tickets with open date prompt.


    i am able to get open_date, resolve_date with right date format like DDMMYY HH:MM:SS


    My requirement is: I want add a column in this report as Age of the ticket

    it should calculate Open Date - Current Date and display as DAYS:HRS:MINS:SECS


    Please help me with formula



    Saravanakumar Kumbalingam