netWorkDays not working?

I am trying to track the number of days between 2 days (using only work days).

The netWorkDays function would be perfect but it doesn’t seem to be working.
I thought it could have been how I was setting up my fields so I created a simple table with just 2 dates and the difference, but the answer is always zero.


So is this a knack bug or do I just have something set up wrong?
Anyone got this to work?

You’ll want to try setting that equation to a Numeric type instead of a Date type. That’ll give you the correct result.

1 Like

Thanks, @Bill that worked. You may consider removing that formula from the date function dropdown list since it doesn’t work there.