0
Bug in Ninox workdays() formula
As a member of the Ninox beta team, I am no longer sure where to report bugs. However, I did find a bug with the workdays() formula.
According to https://docs.ninox.com/en/script/function-overview/functions/workdays, if you provide a start and end date, Ninox will relay a number of weekdays (their manual states Monday-Friday), however the formula calculates from Tuesday-Saturday.
let startdt:=12/19/2022
let enddt:=12/26/2022
workdays(startdt,enddt)
Formula above is not exact, however if add the proper date values for the listed dates, you will not receive 5 as an answer. Instead will receive four.
Per, https://docs.ninox.com/en/script/function-overview/functions/weekday, Ninox weekday() calculation follows this format:
Monday = 0 Tuesday = 1 Wednesday = 2 Thursday = 3 Friday = 4 Saturday = 5 Sunday = 6
I am sure the workdays() codebook sees differently.
Reply
Content aside
- 1 yr agoLast active
- 37Views
-
1
Following