RE: Get next Tuesday. Or the one after

Thanks all, when I said "I want to know what will be the next planned date of the
job.", I wasn't clear. I meant my program needed to know it. The user currently displays this date on the screen for a client, but the date shown is calculated. It is supposed to represent the next planned date for a particular transaction. Of course, it is only theoretical and the real date is only known by the scheduler. The manager has already gone ahead and entered these dates into a file for access by the program.

-----Message d'origine-----
De : midrange-l-bounces@xxxxxxxxxxxx
[mailto:midrange-l-bounces@xxxxxxxxxxxx] De la part de
Lennon_s_j@xxxxxxxxxxx
Envoyé : jeudi 30 septembre 2010 02:49
À : midrange-l@xxxxxxxxxxxx
Objet : Re: Get next Tuesday. Or the one after

Don't know if I totally understand your requirements, but you
can easily get the week of the year with SQL:

select week(current date) from sysibm/sysdummy1

"The WEEK function returns an integer between 1 and 54 that
represents the week of the year. The week starts with Sunday,
and January 1 is always in the first week."

But I suspect that this definition of week number may not
suit your requirements.

You can get back a 0 or 1 from an SQL expression like this:

select mod(
(days(date(current date)) -
days(date('2010-01-05'))
)/7
,2)
from sysibm/sysdummy1

and if you combine something like the above with
dayofweek(current date) that might be what you want.

It's not very clear what is going on, so the algorithm might
be better in RPG.

Sam

On 9/29/2010 9:04 AM, David FOXWELL wrote:

Hi all,

I have a 3 jobs J1, J2 and J3 that will run every two weeks

on Tuesday, Wednesday and Thursday respectively.

I want to know what will be the next planned date of the

job. Eg, today is the 29th, J3 will run either tomorrow or
the 6th October.

If I set a reference date as the first Tuesday of this

year, ie, the 5th of January, can I get my job date from any
given date?

I was thinking of setting the 5th of January as week 1, so

to find my date for the next J1, I would calculate the number
of weeks between the 5th of January and today, divide by 2
to see if it's this week or next week and get the next Tuesday.

Am I making any sense? Would SQL or RPG be the best tool?

--
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.