10-20-2016 08:53 AM
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.