Calculate Business Day
Calculate Business Day
(OP)
I have a problem calculating business day because it is short on one day:
For example:
TODAYDATE/WYYMD=&BEG;
DIFF/I8=DATEDIF(TODAYDATE, ENDDATE, 'BD');
Suppose TODAYDATE = 20041211 (Saturday)
ENDDATE = 20041218 (Saturday)
The diff will come out as 4; however, I wanted to come out as 5. The answer 5 will give me Monday, Tuesday, Wednesday, Thursday, and Friday.
I understand why it is giving me 4 because
20041217(Friday) - 20041213(Monday) = 4 days
Is there a code that work around this problem in order for me to get an answer of 5.
Thank you,
For example:
TODAYDATE/WYYMD=&BEG;
DIFF/I8=DATEDIF(TODAYDATE, ENDDATE, 'BD');
Suppose TODAYDATE = 20041211 (Saturday)
ENDDATE = 20041218 (Saturday)
The diff will come out as 4; however, I wanted to come out as 5. The answer 5 will give me Monday, Tuesday, Wednesday, Thursday, and Friday.
I understand why it is giving me 4 because
20041217(Friday) - 20041213(Monday) = 4 days
Is there a code that work around this problem in order for me to get an answer of 5.
Thank you,
RE: Calculate Business Day
ENDDATE/WYYMD=REQUESTED_DATE;
TODAYDATE/WYYMD=&BEG;
DIFF/I8=DATEDIF(TODAYDATE, ENDDATE, 'BD');
DAYIND/A12= DOWKL(ENDDATE, DAYIND);
RE: Calculate Business Day
ENDDATE/I6YMD = REQUESTED_DATE;
DAYOW/A3 = DOWK(ENDDATE,DAYOW);
Any reason why??
RE: Calculate Business Day
RE: Calculate Business Day
CODE
-SET &ENDDATE = '20041218';
DEFINE FILE CAR
TODAYDATE/WYYMD WITH COUNTRY='&BEG';
ENDDATE/YYMD WITH COUNTRY= '&ENDDATE';
DIFF/I8 WITH COUNTRY=DATEDIF(TODAYDATE, ENDDATE, 'BD');
END
TABLE FILE CAR
PRINT TODAYDATE ENDDATE DIFF
IF COUNTRY EQ 'ENGLAND'
END
and got the following:
CODE
--------- ------- ----
SAT, 2004/12/11 2004/12/18 5