topic NetworkDays in QlikView

NetworkDays

Wed, 15 Feb 2012 15:47:23 GMT

Hi everyone,

I would like to know how to calculate in a load script the number of days between a date lets say IssueDate and the current Date with the NewworkDays functions. Can anyone give me the syntax for doing this please.Thank you!!

NetworkDays

stephencredmond — Wed, 15 Feb 2012 16:14:05 GMT

Hi,

NetWorkDays(IssueDate, Today())

You can also add a list of holidays if you want to exclude them.

Did you check out the help file? It has examples.

Regards,

Stephen

NetworkDays

CELAMBARASAN — Wed, 15 Feb 2012 16:17:57 GMT

Hi,

Syntax for network days.

NetworkDays(startdate,enddate,[holidays])

It calculates number of working days between startdate(should be less than the end date) and enddate,holiday dates is optional u can include it if needed.

Celambarasan