Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hello.
Please suggest a solution to the issue.
I will briefly describe the question. It is necessary when choosing the name filter (Task), to get the correct value by the deadlines for the task, namely the deadline for the task in working days.
In the example, when choosing the filter "task1", which has start_date = 01/13/2017 and finish_date = 01/18/2017. It is necessary to calculate the difference between these dates, taking into account the days off.
The "Calendar" table has 2 fields, Data and Id_status (field value = 0 is the weekend; 1 is working days).
In the attachment screenshots + archive with the application file * .qvf and table in * .xlsx
Thanks in advance.