Next ⏭️📅 & Previous ⏮️📅 Working Day

Options
Danny Roden
Danny Roden Administrator
edited December 2023 in Functions library

Summary

The 2x functions contained within this package relate to identifying the last working date before and next working date after given input (i.e. Excluding Weekends). Note that this function does not take into account Bank Holidays.


Get Date of Next Working Day

image.png

Returns the next working day after a given input (i.e. excluding Saturdays & Sundays).

To understand the logic being applied and to see sample responses for a few example inputs, check out the below screenshot:

image.png


Get Date of Previous Working Day

image.png

Returns the last working day before a given input (i.e. excluding Saturdays & Sundays).

To understand the logic being applied and to see sample responses for a few example inputs, check out the below screenshot:

image.png


Compatibility:

These functions are compatible with all instances of Data Studio from v2.5.1 onwards

Get Date of Next or Previous Working Day.dmx


Tagged:

Categories