Discussion Board for collaboration on QlikView Scripting.
I have a table with dates , in same case the date upside-down, The second date is minor that the first one
the "networkday" function itt gives me mistake -1
Which is the solution?
Go to Solution.
May be simply like this:
If( StartDatefield>EndDateField, NetworkDays(EndDateField,StartDatefield) , NetworkDays(StartDatefield,EndDateField) ) as NetWorkingDays
NetWorkDays(RangeMin(StartDatefield, EndDateField), RangeMax(StartDatefield, EndDateField))
is very very clear, thank you
it's run ok