Re: Date Math 405 CD 5.1

["Al" <macwheel99@xxxxxxxxxx>]

Thanks for the good answers so far.  I am semi-retired IT.  I want to
maximize what I can figure out on my own, before crying uncle.
Each record in FSC is 1-366 days of a year, whether the day is a W-weekend
or whatever.  So now I am looking for:
*	A routine to run on a BPCS date = identify if this is not a valid
calendar date (like all zeros, all nines, or someone keyed in garbage)
*	How to get from BPCS date to 1-366 days that it is in whatever year.
*	After I have figured out what is X business days before that, in a
loop of FSC studies, convert back from YEAR-# days to BPCS date format, to
use with existing old software logic.  I would also have to factor in change
in year, if the starting date is in beginning of January.

I already know, from other software development, how to get a BPCS field
into an array, so as to manipulate access to characters within, one column
position at a time.

I have a dump of which programs access FSC file.  I was hoping I would not
have to do this the hard way, of looking at tons of BPCS source code to find
if there is some routine I can copy, so I not have to look up how-to on
every detail.

Al Mac
-----Original Message-----
From: bpcs-l-bounces@xxxxxxxxxxxx [mailto:bpcs-l-bounces@xxxxxxxxxxxx] On
Behalf Of Al
Sent: Friday, June 03, 2011 2:37 PM
To: 'BPCS ERP System'
Subject: [BPCS-L] Date Math 405 CD 5.1

I have been requested to do a modification, and I am having difficulty
locating good tools to support it.  We are BPCS 405 CD, IBM 5.1.
*	Is there a standard subroutine, like in QSTD, or native IBM, where
we feed in date and it returns if that Date is a Monday Wednesday or
whatever day of week?  This is because they want something to happen based
on business days, not calendar days.
*	Is there a standard subroutine, where I can feed in some date from
some BPCS data, and some # of business days (3 days is their current
interest, but that could change), access the FSC shop calendar, and figure
that out ... like if the BPCS date is for a Monday, then 3 business days
prior to that is the previous Wednesday.

-
Al Mac
 
Assuming no one has any objections, I plan to be deleting work e-mail which
is over a year old, because my e-mail is getting sluggish.