Last day / working date of month 📅
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