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?