How to count a day except weekend?

Sungjoo · July 2, 2018, 1:04am

Hello.

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

How can I count the dates without the weekend?

GvidoN · July 9, 2018, 12:16pm

Good day Sungjoo,

You can use DateDiffWorkdays() function for that.

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

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

Gvido Neilands,
gvido@flex.bi,
eazyBI service partner