[Search for users]
[Overall Top Noters]
[List of all Conferences]
[Download this site]
Title: | FOCUS, from INFORMATION BUILDERS |
|
Moderator: | ZAYIUS::BROUILLETTE |
|
Created: | Thu Feb 19 1987 |
Last Modified: | Mon May 05 1997 |
Last Successful Update: | Fri Jun 06 1997 |
Number of topics: | 615 |
Total number of notes: | 1779 |
67.0. "CALC. DAYS BTW DATES" by TWEED::D_WHITE () Fri May 13 1988 10:52
Does anybody have a routine that calculates the number of days
between to dates excluding weekends and DEC holidays in FOCUS?
So far I have been able to use the ZZXCLS file from MAXCIM and
subtract the field MFG_DAY of date_a (which does not count weekends or
holidays) from the MFG_DAY of date_b. This works great until I get
a date that is a weekend or holiday (which is on my input database)
which returns me a value of 0.
This then throws the subtraction out the window, any ideas on a way
to read a focus file and perform a loop if I need to add a day to
the date when I get a zero MFG_DAY value.
Pre-thanks
Dave White
T.R | Title | User | Personal Name | Date | Lines
|
---|