Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hello everybody..........
I have a table with dates , in same case the date upside-down, The second date is minor that the first one
12-07-2013 30-06-2013
the "networkday" function itt gives me mistake -1
tobe -10
not -1
Which is the solution?
thak you
May be simply like this:
If( StartDatefield>EndDateField, NetworkDays(EndDateField,StartDatefield) , NetworkDays(StartDatefield,EndDateField) ) as NetWorkingDays
May be simply like this:
If( StartDatefield>EndDateField, NetworkDays(EndDateField,StartDatefield) , NetworkDays(StartDatefield,EndDateField) ) as NetWorkingDays
Or
NetWorkDays(RangeMin(StartDatefield, EndDateField), RangeMax(StartDatefield, EndDateField))
Jonathan
HHHHHHHOOOOOOOOO ¡
is very very clear, thank you
it's run ok