Skip to content
dynamic planning
Vacation Dates
DB Planning
DB Periods
DB Intervals
More
Share
Explore

icon picker
Vacation Dates

Based on an integrated planning
Christiaan Huizer

Intro

Below the steps we steps we made to get the job done.
step01 → Get all vacation dates with exceptions from the holidays
step02 → We evaluate each date from step01 to check for the period we work with
Step03 → based on the periodes and weekday we get a list of all fitting dates
Step04 → we use the Remainder() to filter out the dates fitting the interval logic

Vacation Hours
0
Name
employee
fromDate
untilDate
step03
step04-solution
theCountedDays
1
Laurelenn Peeters enjoys 20 vacation days between Sun, Jan 1, 2023 → Thu, Jun 1, 2023
Laurelenn Peeters
1/1/2023
6/1/2023
​​​​​​​​​​[1/13/2023][1/14/2023]​​​​​[1/20/2023][1/21/2023]​​​​​[1/27/2023][1/28/2023]​​​​ Show 119 more
[1/20/2023][1/21/2023][2/3/2023][2/4/2023][2/17/2023][2/18/2023][3/3/2023][3/4/2023][3/17/2023][3/18/2023][3/31/2023][4/1/2023][4/14/2023][4/15/2023][4/28/2023][4/29/2023][5/12/2023][5/13/2023][5/26/2023][5/27/2023]
20
There are no rows in this table
⁠
Read about how to set up your own dynamic planning ⤵️

⁠
Loading
medium.com
⁠
⁠
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.