AddWorkdays Quicksight calc field function not working

0

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.

질문됨 5달 전101회 조회
1개 답변
0

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:

DayWeekdaynumWorkDays
December 1stFriday0
December 2ndSaturday0
December 3rdSunday0
December 4thMonday1
December 5thTuesday2
December 6thWednesday3
December 7thThursday4
December 8thFriday5
December 9thSaturday5
December 10thSunday5
December 11thMonday6
December 12thTuesday7
December 13thWednesday8
December 14thThursday9
AWS
Vitor B
답변함 5달 전

로그인하지 않았습니다. 로그인해야 답변을 게시할 수 있습니다.

좋은 답변은 질문에 명확하게 답하고 건설적인 피드백을 제공하며 질문자의 전문적인 성장을 장려합니다.

질문 답변하기에 대한 가이드라인

관련 콘텐츠