topic Calculating Networkdays using two dates in QlikView

Calculating Networkdays using two dates

Sunil_Kenth — Tue, 03 Apr 2012 14:01:33 GMT

Hi,

I have a start date and a finish date and i would like to calculate the number of working days between the start date and end date. At the moment, in the script i have [finish date] - [start date] as Days which give me a count, however this is not excluding the weekend and therefore the number is incorrect.

i have also tried networkdays([finish date], [start date]) as Days but this just gives me a 0 and 1 flags.

Does anyone know the syntax that i need to use?

Calculating Networkdays using two dates

swuehl — Tue, 03 Apr 2012 14:07:18 GMT

networkdays function should be correct, but try first parameter start date, second end date.

Calculating Networkdays using two dates

Sunil_Kenth — Tue, 03 Apr 2012 14:11:55 GMT

Hi Swuehi, thanks for the response. Can you please clarify, i'm not sure what you mean?

Thanks,

Sunil

Calculating Networkdays using two dates

Anonymous — Tue, 03 Apr 2012 14:21:09 GMT

I guess he means just to change the order of the parameters: networkdays([start date], [finish date]).

Calculating Networkdays using two dates

Sunil_Kenth — Tue, 03 Apr 2012 14:30:18 GMT

Ahh i see - yes that worked! Sometimes youre not able to see the wood from the trees!!

Thanks very much.

Sunil