WorkDay Functions
Functions to list the number of work days in period , determine if a given date is a work day, add work days to a given date.
Uses a table of holidays and a tally table.
2019-09-24 (first published: 2019-09-04)
2,206 reads
Workdays
Add working days but avoid holidays
A function to add or subtract working days taking into account weekends and using a table of non-working days.
2019-07-10 (first published: 2019-06-26)
4,671 reads
Add working days but avoid holidays
A function to add or subtract working days taking into account weekends and using a table of non-working days.
2019-05-01
922 reads
Add working days but avoid holidays
A function to add or subtract working days taking into account weekends and using a table of non-working days.
2019-04-25 (first published: 2019-04-18)
692 reads
Blogs
Azure Workbooks
I’m saddened that the Workspace Summary is being deprecated in Log Analytics Workspace. I...
SQL Prompt Tips–Using $surroundtext$ in a Snippet
By Steve Jones
A user on the SQL Community Slack was asking about what the $surroundtext$ variable....
SQL Server Quickie #46 – SQL Server on Linux
Today I have uploaded SQL Server Quickie #46 to YouTube. This time I’m talking...
Forums
The World of Data Science
Comments posted to this topic are about the item The World of Data Science
PowerQuery in SSIS... is it only in 2023?
First off, I'm terrible at SSIS... I'm trying to create a PowerQuery data source,...
Slicing status based on conditions
Hi, I have a table ShipperStatusHistory that tracks orders, Shipping status and relay points...
Ask SSC