I have 2 date fileds like.

[#1]

I have 2 date fileds like.

date                 today's

12-1-2016        5-2-2016

1-1-2016          5-2-2016

I want calculate the range of two fileds and that range count doesn't calculate the weekends dates.

example:

date                      today's                range

12-1-2016             5-2-2016              19

[Gysbert_Wassenaar · Accepted solution]

Networkdays(date, today())

[sathishkumar_go]

Hi,

Try this

Test:
LOAD * INLINE [
Date, Todays
12-1-2016, 5-2-2016
1-1-2016, 5-2-2016
];

Test1:
load
*,
networkdays (DATE#(Date,'DD-M-YYYY'), DATE#(Todays,'DD-M-YYYY')) as Test2
resident Test;

drop table Test;

--Sathish

[#4]

Thank you so much Gysbert.

I want to remove some holidays and special dates in the calculations. ...can u pls..help me fst..

[Gysbert_Wassenaar]

The NetWorkDays function accepts a list of dates as third, fourth.... nth parameter. You can use that to except that list of dates from the calculation of the net work days between a start and end date. Just add your holidays and special dates as additional parameters to the NetWorkDays function.

[#6]

Hi Gysbert,

can u give me one sample expression.

I wrote expression like this.

networkdays(date,today(26/01/2016)). its  showing correct value.

how can I add 2 more dates in that expression...

Thanks,

Kumar.@@

[Gysbert_Wassenaar]

See this document: Find Net Working Days

[#8]

Thank you so much Gysbert.

[varshavig12]

Network

T1:

load * inline [

date             

1/12/2016,              

];

load networkdays(date,today(),'1/26/2016','1/27/2016') as noOfDays

resident T1;

note: the bold part is optional( for holidays)

[oknotsen]

If your question is now answered, please flag the correct answer with Correct Answer. If not, please make clear what part of your question you still need help with.