# netWorkDays not working?

**URL:** <https://forums.knack.com/t/networkdays-not-working/13240>\
**Category:** Get Answers\
**Created:** [October 17, 2022, 4:56am UTC](https://forums.knack.com/t/networkdays-not-working/13240 "2022-10-17T04:56:02Z")\
**Posts on this page:** 4\
**Page:** 1

<div class="post-metadata">

**Author:** ![Adrian\_vD](https://avatars.discourse-cdn.com/v4/letter/a/f08c70/32.png) [@Adrian\_vD](https://forums.knack.com/u/Adrian_vD)\
**Post date:** [October 17, 2022, 4:56am UTC](https://forums.knack.com/t/networkdays-not-working/13240/1 "2022-10-17T04:56:02Z")

</div>

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.

 ![image](https://us1.discourse-cdn.com/flex020/uploads/knack/original/2X/e/e40de18c74482f397f53dadff29f20be6f7f7359.png)  
 ![image](https://us1.discourse-cdn.com/flex020/uploads/knack/original/2X/e/ef8e0fd7bdbe22558a0d2f62c4a2c6eb7884c28d.png)

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

---

<div class="post-metadata">

**Author:** ![Kat](https://sea2.discourse-cdn.com/flex020/user_avatar/forums.knack.com/kat/32/2834_2.png) [@Kat](https://forums.knack.com/u/Kat)\
**Post date:** [October 17, 2022, 4:58pm UTC](https://forums.knack.com/t/networkdays-not-working/13240/2 "2022-10-17T16:58:11Z")

</div>

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

---

<div class="post-metadata">

**Author:** ![Adrian\_vD](https://avatars.discourse-cdn.com/v4/letter/a/f08c70/32.png) [@Adrian\_vD](https://forums.knack.com/u/Adrian_vD)\
**Post date:** [October 17, 2022, 11:28pm UTC](https://forums.knack.com/t/networkdays-not-working/13240/3 "2022-10-17T23:28:44Z")

</div>

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

---

<div class="post-metadata">

**Author:** ![Laurent](https://sea2.discourse-cdn.com/flex020/user_avatar/forums.knack.com/laurent/32/2855_2.png) [@Laurent](https://forums.knack.com/u/Laurent)\
**Post date:** [October 19, 2023, 3:40pm UTC](https://forums.knack.com/t/networkdays-not-working/13240/4 "2023-10-19T15:40:51Z")

</div>

After a solid hour scratching my head, I finally found this post which explains why netWorkDays didn’t work for me. -\_-

AND on top of that I had to deal with another problem, because I get the wrong results if I do:  
_Answer_=netWorkDays(_my\_date, currentTime()_)

But if I do:  
_Today_=currentTime()  
Answer=netWorkDays(_my\_date, Today_)  
then it works…

I really feel that the documentation on how to work with dates should be expanded. Maybe it is just me, but this rather basic feature gives me rather frequent headaches.