RE: [RBASE-L] - eliminate weekends

@googlegroups.com] On Behalf Of Ryan Blanchard Sent: Monday, May 4, 2020 7:39 PM To: rbase-l@googlegroups.com Subject: Re: [RBASE-L] - eliminate weekends Hi James, You can use the DNW function to get the next business day from a specific date. One possible option

Re: [RBASE-L] - eliminate weekends

James, Two possible solutions: 1. by using Switch / Endsw command   SET VAR V_CURRENT_DAY = (IDWK(.#DATE))   SWITCH (.V_CURRENT_DAY)     CASE 1   SET VAR V_WORKINGDAY_7 = (.#DATE + 9)   BREAK ...     CASE 5   SET VAR V_WORKINGDAY_7 = (.#DATE + 11)   BREAK   ...  

RE: [RBASE-L] - eliminate weekends

@googlegroups.com Subject: Re: [RBASE-L] - eliminate weekends Hi James, You can use the DNW function to get the next business day from a specific date. One possible option: -- SET VAR vtest1 DATE = ( DNW ( #DATE ) ) SET VAR vtest2 DATE = ( DNW ( .vtest1 ) ) SET VAR vtest3 DATE

Re: [RBASE-L] - eliminate weekends

Hi James, You can use the DNW function to get the next business day from a specific date. One possible option: -- SET VAR vtest1 DATE = ( DNW ( #DATE ) ) SET VAR vtest2 DATE = ( DNW ( .vtest1 ) ) SET VAR vtest3 DATE = ( DNW ( .vtest2 ) ) SET VAR vtest4 DATE = ( DNW