RE: Week of the month

I haven't been reading every post on this one (so many!) but the first thing
that popped into my head was that, with all the work you are putting in on
this, trying to come up with the perfect algorithm... you could probably
create your own "Number of Week" database for the next 10 years, keying it
in manually, in less time than it will take to test and perfect this "day of
week" algorithm.


I guess it depends on whether you are most interested in solving the problem
in a timely manner or doing it for the sheer fun of figuring out the
solution programmatically.




-----Original Message-----
From: midrange-l-bounces@xxxxxxxxxxxx
[mailto:midrange-l-bounces@xxxxxxxxxxxx] On Behalf Of John McKee
Sent: Thursday, December 11, 2008 8:27 AM
To: midrange-l@xxxxxxxxxxxx
Subject: RE: Week of the month

It will work, as long as the requirement is to run every other week. I
wonder
how long that will be an accurate requirement, however. The data area
technique only fails if the additional requirement of second and fourth
week is
applied.

Quoting Alan Shore <AlanShore@xxxxxxxx>:

Actually - my impression is that this wont work for the problem at hand.
for example
1st Tuesday - data area 0 do not run, change to 1
2nd Tuesday - data area 1 DO run, change to 0
3rd Tuesday - data area 0 do not run, change to 1
4th Tuesday - data area 1 DO run, change to 0
5th Tuesday - data area 0 do not run, change to 1
1st Tuesday - data area 1 DO run, change to 0

The 5th Tuesday of the month screws it up for the following month


Alan Shore
Programmer/Analyst, Distribution
E:AShore@xxxxxxxxxxx
P:(631) 200-5019
C:(631) 880-8640
"If you're going through Hell, keep going" - Winston Churchill


midrange-l-bounces@xxxxxxxxxxxx wrote on 12/11/2008 08:32:33 AM:

-----Original Message-----
From: midrange-l-bounces@xxxxxxxxxxxx
[mailto:midrange-l-bounces@xxxxxxxxxxxx] On Behalf Of Chris Bipes
Sent: Wednesday, December 10, 2008 10:39 PM
To: Midrange Systems Technical Discussion
Subject: RE: Week of the month

create a *LGL data area. If = 0, run job and change to 1, if equal 1,
change to 0 and do not run. Run your job weekly and let the data area
control how far it goes.


Chris Bipes
Director of Information Services
CrossCheck, Inc.

Now, that is clever! I'll need to remember the technique.

--
John McKown
Systems Engineer IV
IT

Administrative Services Group

HealthMarkets(r)
Administrative Services Group
9151 Boulevard 26 * N. Richland Hills * TX 76010
(817) 255-3225 phone * (817)-961-6183 cell
john.mckown@xxxxxxxxxxxxxxxxx * www.HealthMarkets.com

Confidentiality Notice: This e-mail message, including any attachments,
is for the sole use of the intended recipient(s) and may contain
confidential or proprietary information. Any unauthorized review, use,
disclosure or distribution is prohibited. If you are not the intended
recipient, please contact the sender by reply e-mail and destroy all
copies of the original message.

--
This is the Midrange Systems Technical Discussion (MIDRANGE-L) mailing

list

To post a message email: MIDRANGE-L@xxxxxxxxxxxx
To subscribe, unsubscribe, or change list options,
visit: http://lists.midrange.com/mailman/listinfo/midrange-l
or email: MIDRANGE-L-request@xxxxxxxxxxxx
Before posting, please take a moment to review the archives
at http://archive.midrange.com/midrange-l.

--
This is the Midrange Systems Technical Discussion (MIDRANGE-L) mailing

list

To post a message email: MIDRANGE-L@xxxxxxxxxxxx
To subscribe, unsubscribe, or change list options,
visit: http://lists.midrange.com/mailman/listinfo/midrange-l
or email: MIDRANGE-L-request@xxxxxxxxxxxx
Before posting, please take a moment to review the archives
at http://archive.midrange.com/midrange-l.