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.