Using NetWorkDays function with Holiday

[User6]

In the Qliksense script I defined the following variable :

Set vDiff = NetWorkDays ([A] , [B] , '05/26/2022', '05/27/2022');

A and B are columns of a table.

Assuming :

[A] = 05/25/2022 (Wednesday)

[B] = 05/30/2022 (Monday),

I hope to get as result 2 but I got 4.

It seems to me that the Holidays are not taken into account. Does anyone see a mistake in what I wrote? Thanks in advance 🙂

[Or · Accepted solution]

NetWorkDays ('25/05/2022' , '30/05/2022' , '26/05/2022', '27/05/2022')

Looks fine to me. This also works from within a variable and returns 2. Perhaps you have mismatching date formats (in which case the two holidays wouldn't be recognized as dates)? You could check that by replacing them with matching MakeDate() functions, most likely.