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 ( .vtest3 ) )
...
----------------------------------
and so on until you get the number of days you need since the function
increments by one. One line for every day added and the output variable
being what the last line is set to.
Another Option:
----------------------------------
SET VAR vloopcount1 = 0
SET VAR vloopcount2 = 7
SET VAR vtestdate DATE = #date
WHILE vloopcount1 < vloopcount2 THEN
SET VAR vtestdate = ( DNW ( .vtestdate ) )
SET VAR vloopcount1 = ( .vloopcount1 + 1 )
IF vloopcount2 <> 0 THEN
Continue
ENDIF
BREAK
ENDWHILE
----------------------------------
This option allows you to not have so many variables with the output
variable being vtestdate. Also, it's easy to change the number of days by
changing what vloopcount2 is set to.
Ryan
On Mon, May 4, 2020 at 4:51 PM Jim Belisle <[email protected]> wrote:
> 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.
>
>
>
> James Belisle
>
>
>
> *Making Information Systems People Friendly Since 1990*
>
> [image: cid:[email protected]]
>
>
>
> --
> For group guidelines, visit
> http://www.rbase.com/support/usersgroup_guidelines.php
> ---
> You received this message because you are subscribed to the Google Groups
> "RBASE-L" group.
> To unsubscribe from this group and stop receiving emails from it, send an
> email to [email protected].
> To view this discussion on the web visit
> https://groups.google.com/d/msgid/rbase-l/CY4PR0201MB3394F5AF4E44571D0399CE78A0A60%40CY4PR0201MB3394.namprd02.prod.outlook.com
> <https://groups.google.com/d/msgid/rbase-l/CY4PR0201MB3394F5AF4E44571D0399CE78A0A60%40CY4PR0201MB3394.namprd02.prod.outlook.com?utm_medium=email&utm_source=footer>
> .
>
--
For group guidelines, visit
http://www.rbase.com/support/usersgroup_guidelines.php
---
You received this message because you are subscribed to the Google Groups
"RBASE-L" group.
To unsubscribe from this group and stop receiving emails from it, send an email
to [email protected].
To view this discussion on the web visit
https://groups.google.com/d/msgid/rbase-l/CADj97FnGiZf%3D-yTntr9qH6nbWYjpnPAHwW_t%2Byvqm1oDfFba0g%40mail.gmail.com.
