Re: Utility for repeating dates

[James Perkins <jrperkinsjr@xxxxxxxxx>]

I would take a look at the SQL data functions. There is a DayOfWeek(Date())
function that will return 1 for Sunday and 7 for Saturday which will give
you the weekdays. There is also DayOfWeek_ISO which will return 1 for Monday
7 for Sunday.

There are probably some formulas out there to handle the others. I have
written an RPG procedure to do the DayOfWeek logic using Zeller's
congruence. That might leed you to some other forumlas.

I actually have a whole calendar prompt program I wrote, doesn't really do
anything fancy except show a subfile with the days and return the ISO date.
I think it was Booth Martin that has source to one on this site too.

You could always start at the first day of the month and increment the days
until you reach a weekend or something like that.

Just some thoughts.

--
James R. Perkins


On Thu, Mar 5, 2009 at 07:27, Ewout N Boter <ewout.boter@xxxxxxxxxx> wrote:

> Hi all,
>
> I am working on a project involving repeating dates. The user should be
> able to select differents methods for specifying the dates. For example:
> each second Tuesday of the month for the next 12 months. Or: the first
> non-weekend day in the month for the next 18 months. For anyone familiar
> with Lotus Notes: when a new meeting is created in Notes, there is a
> window Repeat Options. If I could somehow copy that window, then I would
> be golden.
>
> Now, I was thinking that I am probably not the first one looking for
> something like this. Therefore, I have done some searching on the
> internet, but so far I have not found something useful. Hopefully, someone
> on this list can point me in the right direction.
>
> For your information: the functionality should be integrated in a
> 5250-application written in RPG. If there would be a utility written in
> RPG, then that would be great. But it is more likely that there will be
> utilities written in Java. In that case, it would be a real challenge to
> integrate such a utility in the existing application, but I would
> certainly give it a shot.
>
> Thanks in advance for any suggestions.
>
> Ewout
>
> (This message was cross-posted in java400-l and in rpg400-l.)
> --
> This is the Java Programming on and around the iSeries / AS400 (JAVA400-L)
> mailing list
> To post a message email: JAVA400-L@xxxxxxxxxxxx
> To subscribe, unsubscribe, or change list options,
> visit: http://lists.midrange.com/mailman/listinfo/java400-l
> or email: JAVA400-L-request@xxxxxxxxxxxx
> Before posting, please take a moment to review the archives
> at http://archive.midrange.com/java400-l.