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
Discussion posts and replies are publicly visible