Re: Get next Tuesday. Or the one after (VALUES)

On Fri, 2010-10-01 at 16:05 -0400, rob@xxxxxxxxx wrote:

There's two ways to skin that cat:
1 - RTM
2 - test it with
values week('12/31/20someyearthatfitsyourcriteria')

I apologize for being too terse.

I fear that I have lost the context for which you suggested
values week(current date)
but ISTM that this will lead to execution in, let's say, the first week
of the year, the third week, the fifth week, and so forth (or second,
forth, sixth, and so forth). After a year with 53 weeks, you get two
executions scheduled just one week apart (or three weeks apart). That
does not match what I understood from David's original question.

HTH,
Terry.

Rob Berendt
--
Group Dekko
Dept 1600
Mail to: 2505 Dekko Drive
Garrett, IN 46738
Ship to: Dock 108
6928N 400E
Kendallville, IN 46755
http://www.dekko.com





From: Terrence Enger <tenger@xxxxxxxxxxxxxxxx>
To: Midrange Systems Technical Discussion <midrange-l@xxxxxxxxxxxx>
Date: 10/01/2010 04:03 PM
Subject: Re: Get next Tuesday. Or the one after (VALUES)
Sent by: midrange-l-bounces@xxxxxxxxxxxx



On Fri, 2010-10-01 at 13:56 -0400, rob@xxxxxxxxx wrote:

You had a good reply from someone else but let me summarize it:

From STRSQL

VALUES WEEK(CURRENT DATE)

From imbedded sql in rpg

EXEC SQL VALUES WEEK(CURRENT DATE) INTO :week;

Hmm. How does that work in the year after a year with 53 weeks?