Re: Date interval Sans Weekends

["Al Barsa, Jr." <barsa2@xxxxxxx>]

At 09:47 AM 3/31/98 -0600, you wrote:
>I'm looking for a formula to retrieve the interval between 2 dates that
>strips out weekends.
>Thought I'd check here before trying to reinvent the wheel.
>
There's a TAA Tool called Calculate Date Difference (CLCDATDIF), which will
give you the difference in dates between two dates.  You can calculate the
number of weekends in that time span by division by 7.  You then need to
make fine adjustments for start and end dates.  The Retrieve Date (RTVDAT)
TAA Tool will tell you if any specific date is a particular day of the week.

Al



Al Barsa, Jr. - Account for Midrange-L
Barsa Consulting, LLC.  
400 > 390

Phone:  914-251-9400
Fax:    914-251-9406





Private mail should be sent to barsa@ibm.net
+---
| This is the Midrange System Mailing List!
| To submit a new message, send your mail to MIDRANGE-L@midrange.com.
| To unsubscribe from this list send email to MIDRANGE-L-UNSUB@midrange.com.
| Questions should be directed to the list owner/operator: david@midrange.com
+---