AnsweredAssumed Answered

HOW To: Trying to calculate days based on Audit Trail data

Question asked by juan.segovia on Jan 23, 2013
Latest reply on Jan 24, 2013 by juan.segovia
Hi, I'm facing the same issue described on this unanswered post:


One of the requirements for my report is to find out how many days investments where in cetain statuses. as our projects 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.

Juan Segovia