CA Service Management

Age of ticket in jasper report

  • 1.  Age of ticket in jasper report

    Posted May 23, 2019 06:40 AM

    Hi,

     

    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

     

    Thanks,

    Saravanakumar Kumbalingam