Skip to main content
Question

120-days rule in Denmark

  • Oct 13, 2026 12:45 PM UTC
  • 2 replies
  • 76 views
  • Translate All

Hi Danish Bob users,

I would like to receive an automated report whenever an employee reaches 100 days of sick leave within a rolling 365-day period.

Has anyone managed to set up a smart solution for this, or how do you currently handle it?

Best regards,

Preben

2 replies

Nicolas Patin

Hi Preben,

So it depends if you have manage the sick leave by a “Leave” or by a “Time-Off”.

In both ways, you can create a formula in a report and use the following formula example;

DATEDIF({{Lifecycle##%%/internal/lifecycle/effectiveDate}}, {{Lifecycle##%%/internal/lifecycle/endEffectiveDate}},"D")

This one will give you the number of days between 2 dates, here example for a Leave that is managed by LifeCycle category.

Feel free to use other fields if it’s the one from Time-Off.

Hope this could help?

Nico

Translate

Hi Nicolas

Thanks for your input. I’ll look into that option.

Br. Preben

 

Translate