Best practice to calculate days based on Audit Trail data

Discussion created by waely on Jun 7, 2011
Latest reply on Jun 13, 2011 by Chris_Hackett
One of the requirements for my report is to find out how many days incidents where in cetain statuses. as our incidents go from New -> In-Test --> review --> approved etc...
I need to know how many days my incidents were in New status then In-Test etc. I thought to use the audit trail and to use the Value_Before and Value_After attribute to calculate the difference between dates but I'm having hard time with that..

does anyone have any idea or suggestion?
thank you.