AddWorkdays Quicksight calc field function not working

Question

Code: addWorkDays(truncDate('MM',{datanet_run_date}),9)

Lets say month is December 2023. AddWorkdays('2023-12-01',9)  outputs  2023-12-14 which is not 9 workdays? It is 10.

Answer

Please note that December 1st was on a Friday. So December 2nd, 3rd, 9th and 10th are not work days. So you have 4 non work days, then if you calculate 1 (first day of the month) + 9 (numWorkDays) + 4 (non work days) = 14.

The table below may make it easier to visualize the calculation. numWorkDays is 0 for December 1st as it is the starting point:

|Day|Weekday|numWorkDays|
|---|---|---|
|December 1st|Friday|0|
|December 2nd|Saturday|0|
|December 3rd|Sunday|0|
|December 4th|Monday|1|
|December 5th|Tuesday|2|
|December 6th|Wednesday|3|
|December 7th|Thursday|4|
|December 8th|Friday|5|
|December 9th|Saturday|5|
|December 10th|Sunday|5|
|December 11th|Monday|6|
|December 12th|Tuesday|7|
|December 13th|Wednesday|8|
|December 14th|Thursday|9|

Day	Weekday	numWorkDays
December 1st	Friday	0
December 2nd	Saturday	0
December 3rd	Sunday	0
December 4th	Monday	1
December 5th	Tuesday	2
December 6th	Wednesday	3
December 7th	Thursday	4
December 8th	Friday	5
December 9th	Saturday	5
December 10th	Sunday	5
December 11th	Monday	6
December 12th	Tuesday	7
December 13th	Wednesday	8
December 14th	Thursday	9

AddWorkdays Quicksight calc field function not working

Relevant content