I'm not aware of any function that will do it. Here's a simple while loop, in
case you don't already do this. vCount would have the #days
SET VAR vDays = (.vedate - .vbdate)
SET VAR vCount INT = 0, vLoop INT = 0
WHILE vLoop <= .vDays THEN
SET VAR vTestDate = (.vbdate + .vLoop)
IF (IDWK(.vTestDate)) BETWEEN 1 AND 5 THEN
SET VAR vCount = (.vCount + 1)
ENDIF
SET VAR vLoop = (.vLoop + 1)
ENDWHILE
Karen
-----Original Message-----
From: Dan Goldberg <[email protected]>
To: rbase-l <[email protected]>
Sent: Tue, Sep 5, 2017 1:04 pm
Subject: [RBASE-L] - calculate number of business days
I need to calculate the number of business days between to date values.
Which gives me the number of days. But I need to calculate the number of days
without weekends.
I cannot find a function that will achieve the results in need.
Does anyone have an idea on how to calculate it?
TIA
Dan Goldberg
--
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].
For more options, visit https://groups.google.com/d/optout.
--
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].
For more options, visit https://groups.google.com/d/optout.
