Thx that is what I was thinking of doing. Just a little slower but will work.
Dan Goldberg From: karentellef via RBASE-L [mailto:[email protected]] Sent: Tuesday, September 5, 2017 12:07 PM To: [email protected] Subject: Re: [RBASE-L] - calculate number of business days 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]<mailto:[email protected]>> To: rbase-l <[email protected]<mailto:[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]<mailto:[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]<mailto:[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.
