Explore

DB Employees

DB Employees

NextBD

step03a

step03

Copy of correctOutcome

15/08/2025

[45882458804587945875][45875458734587245868]

8/13/20258/6/2025

21/07/2026

[46224462204621846217][46217462134621146210]

7/21/20267/14/2026

11/03/2026

[4609246091460904608746086460854608446083][4608546084460834608046079460784607746076]

3/11/20263/4/2026

25/04/2026

[4613646135461344613346132461294612846127][4612946128461274612646125461224612146120]

4/24/20264/17/2026

23/09/2025

29/09/2025

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.