[Search for users] [Overall Top Noters] [List of all Conferences] [Download this site]

Conference ilbbak::ibi_focus

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 13: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.RTitleUserPersonal
Name
DateLines