How to count a day except weekend?


I used DateDiffDays() Function to count date.
But, It was counted including the weekend.

How can I count the dates without the weekend?

Good day Sungjoo,

You can use DateDiffWorkdays() function for that.

For example, work days from issue crated to issue closed date:

[Issue].CurrentHierarchyMember.get('Created at'),
[Issue].CurrentHierarchyMember.get('Closed at')
, '67')

Gvido Neilands,,
eazyBI service partner

1 Like