DB Vacation

splitting vacations over the years

Our goal is to distribute the working days over the years aligned with the working schedule that applies for each given date. Each working day follows a day planning, you define the hours per day.

How to use it?

Generate one or multiple working schedules for an employee →

DB Work Schedules⁠

define the working hours per working day: select day planning & confirm with a button

Set the vacation date in

DB Vacation⁠

Press the button → see what happens

DB Vacation

DB Vacation

step07ButtonVariableHours

dateFrom

dateUntil

employees

Update Vacation Balance Variable Hours

12/1/2022

1/9/2023

Canisia Smets

Update Vacation Balance Variable Hours

12/14/2022

12/18/2022

Esty Charlier

Update Vacation Balance Variable Hours

Abby-Gaëlle Declercq

There are no rows in this table

⁠

You can add working schedules,

click here⁠

and you see a different outcome if the date range runs through various working periods. It is a matter of playing.

⁠

below two blogs explaining step by step how the code functions I applied in this template.

⁠

Splitting vacation over years in Coda Dealing with vacations covering multiple years medium.com⁠

⁠

Counting Vacation Hours in Coda Based on irregular working schemas 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.