Skip to content
Template - The Next Working Day
The Next Working Day
DB Vacations
DB Employees
DB Holidays
DB Work Schedules
Test Table
DB Test Holidays
Untitled page
More
Share
Explore

icon picker
DB Employees

DB Employees
0
NextBD
step03a
step03
Copy of correctOutcome
1
15/08/2024
[4551845516455154551145509][4551145509455084550445502]
8/14/20248/7/2024
8/14/20248/7/2024
2
21/07/2024
[45492454904548945485][45485454834548245478]
7/19/20247/12/2024
7/19/20247/12/2024
3
11/03/2024
[45362453594535845357453564535545352][45355453524535145350453494534845345]
3/11/20243/4/2024
3/11/20243/4/2024
4
25/04/2024
[454074540645405454044540145400453994539845397][454004539945398453974539445393453924539145390]
4/25/20244/18/2024
4/25/20244/18/2024
5
23/09/2024
​​
6
29/09/2024
​​
There are no rows in this table
⁠
List(thisRow.NextBD,thisRow.NextBD-7).WithName(root,
Sequence(1, root.Count()).ForEach(CurrentValue.WithName(dateNbr,
Sequence(root.Nth(dateNbr),
root.Nth(dateNbr)-10).ForEach(CurrentValue.WithName(theDateRanges,
[DB Work Schedules].Filter(
employee.Contains(thisRow) and
fromDate <= theDateRanges
).Last().WithName(schedules,
theDateRanges.Filter(CurrentValue.Weekday().Contains(schedules.workingDays.theNumber)).ForEach(CurrentValue.ToDate())
)
)))))

Want to print your doc?
This is not the way.
Try clicking the ⋯ next to your doc name or using a keyboard shortcut (
CtrlP
) instead.