Lloyd,
If the suggestion about using a calendar file is workable for you, then it would be a really simply matter to define a macro in IWP to return the number of working days given in any period given the 2 delimiting dates.
This macro could either be a FUNCTION macro (available for using within a Jacana calculation), or a DERIVED macro available for use on a derived field.
Your decision here would be based on your view as to the opportunity to make use of such a derived value in multiple areas of your data base.
If the calendar file option is not open to you, counting week-days (i.e. days excluding Saturdays and Sundays) is still possible in an IWP FUNCTION or DERIVED macro - just takes a bit more code.
If you want to know more, please feel free to contact me off-line.
Bernard Green
Momentum Utilities Pty Ltd
bgreen@xxxxxxxxxx
Tel: +61 2 9680 6000
NOTE: Momentum Utilities is the author of IWP and Jacana
-----Original Message-----
From: mapics-l-bounces@xxxxxxxxxxxx [mailto:mapics-l-bounces@xxxxxxxxxxxx] On Behalf Of Lloyd Degnon
Sent: Wednesday, 5 March 2008 3:53 AM
To: MAPICS ERP System Discussion
Subject: [MAPICS-L] Any thoughts?
I have created a IWP report that looks at early, late , and on time shipments based on promised date and shipped date. Any ideas how to figure and exclude weekends as days late in the calculations?
Lloyd H. Degnon
I.T. Manager
Ampro Computers, Inc.
5215 Hellyer Ave.
Building #110
San Jose, CA 95138
(408) 360-4365
ldegnon@xxxxxxxxx
(¯`·.(¯`·.www.AmPro.com <
http://www.ampro.com/> .·´¯).·´¯)
_______________________________________________
This is the MAPICS ERP System Discussion (MAPICS-L) mailing list
To post a message email: MAPICS-L@xxxxxxxxxxxx
To subscribe, unsubscribe, or change list options,
visit:
http://lists.midrange.com/mailman/listinfo/mapics-l
or email: MAPICS-L-request@xxxxxxxxxxxx
Before posting, please take a moment to review the archives
at
http://archive.midrange.com/mapics-l.
midrange.com
