In my report I need to show the average number of days beween the time the issue was logged and the time it was resolved. From the database I get two java.util.Date fields. I have created a variable $avg_days.
I have tried something like this with the average calculation but since setTime returns void it doesn't work.
Code:
(new java.util.Calendar().setTime($F{date_accepted}).getTimeinMillis() - new java.util.Calendar().setTime($F{date_logged}).getTimeinMillis())/86400
How to calc average days from two java.util.Date?
in Products
Posted
Hi all,
In my report I need to show the average number of days beween the time the issue was logged and the time it was resolved. From the database I get two java.util.Date fields. I have created a variable $avg_days.
I have tried something like this with the average calculation but since setTime returns void it doesn't work.
Does anyone else have an idea how to do this?