Hi,

I have some code that works out the hours between two dates. Up until now I have been using 'business days' and it seemed to work fine, but today someone has noticed a problem in a few cases, where if there is a day between the two dates, the business days excludes that day. So I tried the working days option 'WD' instead, and it produced the correct results, the time between the two dates including the hours of the day in between.
I would be eternally grateful if someone could explain the difference between the two as I was always under the impression they were essentially the same O.o.

The last thing one wants is for productivity reporting to be wrong! ;-)

DAY_DIFF/I8 = DATEDIF (1_DATE_TIME_FINAL2, 2_DATE_TIME_FINAL2, 'BD');  

DAY_DIFF/I8 = DATEDIF (1_DATE_TIME_FINAL2, 2_DATE_TIME_FINAL2, 'WD');  

Thanks!!

Jinx.

This message has been edited. Last edited by: Jinx,

WD counts week/work days; BD counts business days, meaning workdays that are not holidays. SET BUSDAYS is used to set the work days in the week (usually _MTFTF_). SET HDAY points to a holiday date file. Use ? SET to see the settings for your site. Without a holiday file, I would expect WD and BD to produce the same results for DATEDIFF. But it's possible your site has a holiday file in use that is affecting calculations for some of the date functions, including DATEDIFF.

quote:

(usually _MTFTF_).

What do they call Wednesday in Switzerland then Dan

T

*ponder*

I have set both..so I have the following:

 
SET BUSDAYS = _MTWTF_

SET HDAY = UKUK

So if I used 'BD' would both of the above be taken into account? Or is the first one only for working with 'WD'?

I am getting the incorrect hours from 'BD' even though the holiday file has the correct holidays listed.

Jinx.

Tony, thanks for pointing out my typos. I should learn to type one of these days.

Jinx, I'm no expert on this matter, but I would think WD uses BUSDAYS and BD uses both BUSDAYS and HDAY.

Thanks Dan, I'll do some more testing and come up with a working solution. At least I have some clarification ;-).