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