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 <d...@lancecamper.com>
To: rbase-l <rbase-l@googlegroups.com>
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 rbase-l+unsubscr...@googlegroups.com.
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 rbase-l+unsubscr...@googlegroups.com.
For more options, visit https://groups.google.com/d/optout.

Reply via email to