Last day / working date of month πŸ“…

Danny Roden
Danny Roden Administrator
edited December 2023 in Functions library

Summary

The 2x functions contained within this package relate to identifying the last date of the month (and the last working day of the month) for a given input.


Last Date of Month

This function returns the last date of the month for a given input to help make it easier to assess any business rule logic that requires this as a variable.


See below for a preview of the rule definition and some sample output results:


Last Working Date of Month

Similar to the above function, except that this function gives the user the option of specifying exclusions. This function identifies the last date (within the defined 'working week' range) for a given month.

As you can see, when a user accesses this function they are prompted to specify the start and end day of the week (to define the range of permissable options for the function to select from). To configure the 'start' and 'end of week' fields, the user simply types a number 1-7 which corresponds to the weekday (where Monday = 1 and Sunday = 7).

See below for a preview of the rule definition and some sample output results:


Compatibility:

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