RE: [RBASE-L] - eliminate weekends

2020-05-04 Thread Jim Belisle
Thanks Ryan. I will check that out. James Belisle Making Information Systems People Friendly Since 1990 [cid:image001.jpg@01CD8CE2.FB048F50] From: rbase-l@googlegroups.com [mailto:rbase-l@googlegroups.com] On Behalf Of Ryan Blanchard Sent: Monday, May 4, 2020 7:39 PM To: rbase-l@googlegroups.co

Re: [RBASE-L] - eliminate weekends

2020-05-04 Thread Ryan Blanchard
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

[RBASE-L] - eliminate weekends

2020-05-04 Thread Jim Belisle
I want to get a date in the future based on 7 business days in the future. So how do I add to a present date, let's say 05/04/2020 seven days in the future but eliminate the weekends? I see functions for IDWK and TDWK but am unsure how to create the var that gives me seven business days out. Jam