AnsweredAssumed Answered

SQL for Duration Calculation

Question asked by bfarquhar on Mar 14, 2011
Latest reply on Nov 16, 2016 by Robert Ensinger
Can anyone provide the calculation for Duration in Clarity ?

I need to calculate the duration for a set of tasks. We have added a custom field to tasks and I'm using it to calculate various metrics grouped by that field. One of the requirements is Duration in Business days (m-f) and excluding holidays if possible. I want to make sure I'm calculation my duration the same way Clarity does to avoid any issues.

Does anyone know this calculation or where I could go to get it ? Providing the actual SQL would be awesome !!... but I will take what I can get.

Thanks,
Ben

Outcomes