Networkdays Question

[jerryr125]

Hi - I have a question about the Networkdays function.

I presently have the following in my dataload:

Today(1) - Date(Date#(abcddate,'YYYYMMDD'),'MMDDYYYY') as NumberofDays

Works perfectly BUT I want to remove Saturday/Sunday from the calculation.

Give the current format above of the date fields, what is the best way to approach this with the Networkdays function?

Thanks - Jerry

[danielrozental · Accepted solution]

You should try something like

Networkdays(Date#(abcddate,'YYYYMMDD'),today(1)) as NumberofNetworkDays

Qlik Sense NetworkDays