Hi all,

I'm trying to create a report that shows all current incidents in reopen status, and the amount of time they've been reopened.  This is what I tried, but all I get are 0s:  if(incidents.status_id != 8, date_diff(sysdate(), transactions.created)).

Is there a different date field I should be using to calculate this time?

Thanks!

~Kelli