|
At 07:03 PM 3/31/98 -0500, Al Barsa, Jr wrote: >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 Barsa, Jr. - ------------------------- You might strip in a holiday table/file if you are after true number of work days. Glenn ___________________________________________________ Glenn Ericson, Phoenix Consulting P O Box 701164 East Elmhurst NY 11370-3164 USA Phone 718 898 9805 Fax 718 446 1150 AS/400 & Year 2000- - Solutions Specialists © 1998 copyright, all rights reserved ____________________________________________________ +--- | 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 +---
As an Amazon Associate we earn from qualifying purchases.
This mailing list archive is Copyright 1997-2024 by midrange.com and David Gibbs as a compilation work. Use of the archive is restricted to research of a business or technical nature. Any other uses are prohibited. Full details are available on our policy page. If you have questions about this, please contact [javascript protected email address].
Operating expenses for this site are earned using the Amazon Associate program and Google Adsense.