How to calc average days from two java.util.Date?

[mxc]

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.

Code:

(new java.util.Calendar().setTime($F{date_accepted}).getTimeinMillis() - new java.util.Calendar().setTime($F{date_logged}).getTimeinMillis())/86400

 

 

Does anyone else have an idea how to do this?

[babarincairo]

do you find a solution ?

 

thanks

[joeycn]

try this:

($F{date_accepted}).getTime()

instead of

new java.util.Calendar().setTime($F{date_accepted}).getTimeinMillis()

;)