AnsweredAssumed Answered

Calculated Attribute DateDiff Function

Question asked by ABT_Project_Support on Nov 16, 2018
Latest reply on Nov 21, 2018 by roland.parrotte

Anyone have any experience or expertise using the DateDiff Function and how to exclude non-workdays (Saturday & Sunday)

 

I am using the below function, but that only works if it is always divisible by 7 and assuming the start date begins on a Sunday and ends on a Saturday.

 

((DateDiff(start_date,end_date,""))-((DateDiff(start_date,end_date,"")/7)*2)+1)

Outcomes