Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
You should try something like
Networkdays(Date#(abcddate,'YYYYMMDD'),today(1)) as NumberofNetworkDays
You should try something like
Networkdays(Date#(abcddate,'YYYYMMDD'),today(1)) as NumberofNetworkDays