Re: AW: Week of the year routine

Mark,

Even though SQL is not installed on a machine, the SQL runtime is always available.
If you write a small RPG program (or procedure within a service program) with embedded SQL using the SQL scalar function WEEK to determine the week in the way you described, compile it on a machine with SQL and transfer the compiled object, it will run.

Mit freundlichen Grü�en / Best regards

Birgitta Hauser

"Shoot for the moon, even if you miss, you'll land among the stars." (Les Brown)
"If you think education is expensive, try ignorance." (Derek Bok)
"What is worse than training your staff and losing them? Not training them and keeping them!"

-----Ursprüngliche Nachricht-----
Von: rpg400-l-bounces@xxxxxxxxxxxx [mailto:rpg400-l-bounces@xxxxxxxxxxxx] Im Auftrag von Henrik Rützou
Gesendet: Friday, 15. April 2011 18:39
An: RPG programming on the IBM i / System i
Betreff: Re: Week of the year routine

Mark,

this is not an easy task, first of all - weekday no 1 is in US sunday and in
most europe monday,
second 1. january could be week 52/53 in previous year it all depends on
what weekday 1. january
are

On Fri, Apr 15, 2011 at 6:23 PM, M. Lazarus <mlazarus@xxxxxxxx> wrote:

> Before I reinvent the "calendar file" wheel, does anyone have an
> *RPG* routine that will calculate the week of the year.
>
> A few parameters:
>
> - This machine is on an older OS version (5.3) and does not have the
> SQL feature installed.
>
> - Week 1 of the year starts on January 1. So, for example, in 2010,
> Dec. 26-31 would be the last week of the year (53?). Saturday, Jan
> 1, 2001, is week 1. Monday, Jan 2-8, is week 2, etc.
>
>
> Thank you.
>
> -mark