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

null

Content aside

  • 1 yr agoLast active
  • 35Views
  • 1 Following