I'm trying to using the calworkdays() function to display the number of working days between two datetime variables

I'm trying to using the calworkdays() function to display the number of working days between two datetime variables for a report, but it only seems to produce a result part of the time. The two datetimes I'm using are 'pp!starttime' and a 'pv!datetime' I capture when a specific task is completed. I can verify that both datetimes have a value stored, but the function will only produce a result for a few of the rows. The only time it will seem to work perfectly, is when I limit the results to only pull from Completed processes.

I get the same result with using networkdays() and calworkhours(), which leads me to believe there is another factor interfering with the operation of the all these functions.

Any idea?

Todd
...

OriginalPostID-57681