calculate total number of working days excluding the weekends and holidays using EG building query

Reply
Occasional Contributor
Posts: 13

calculate total number of working days excluding the weekends and holidays using EG building query

i am searching for querry logic to work for calculation of net working days between two dates 

scenario is : if employee rais the toke that he was working say from 10th oct2016 to 18oct2016 at client side so as according to calender its that it has 1 saturday and 1 sunday which should exclude these holidys and give the total no. count of working days which should also include the present date i.e 10th = where the o/p should be 7 working days 

As the holiday master table is been maintained in different dataset which contains these sat and sun.and dates of holidays.

can help me in building loginc in EG using query builder.

 

Frequent Contributor
Posts: 103

Re: calculate total number of working days excluding the weekends and holidays using EG building que

Check this Blog

________________________

- That still only counts as one -

Ask a Question
Discussion stats
  • 1 reply
  • 383 views
  • 1 like
  • 2 in conversation