topic Re: Calculate weeknumber with a DCL-script in Operating System - OpenVMS

Calculate weeknumber with a DCL-script

geir_2 — Tue, 10 Jan 2006 05:12:18 GMT

is it possible to use a simple DCL-script to calculate the actual weeknumber? 1-52 (53, some special events)

Maybe it's possibel to use daynumber in the year together with a modulo function?

Thanks
Geir

Re: Calculate weeknumber with a DCL-script

Marc Van den Broeck — Tue, 10 Jan 2006 05:19:43 GMT

Geir,

use the lexical f$cvtime to get the weeknumber.

Rgds
Marc

Re: Calculate weeknumber with a DCL-script

geir_2 — Tue, 10 Jan 2006 05:33:15 GMT

Hi,

I have problem to find suitable arguments to calculate weeknumber. Myabe I have som trouble to see the correct argument??

geir

Re: Calculate weeknumber with a DCL-script

Ian Miller. — Tue, 10 Jan 2006 05:34:46 GMT

Does this do want you want?
WEEKNO = 1+ f$cvtime(,"ABSOLUTE","DAYOFYEAR")/7

Re: Calculate weeknumber with a DCL-script

Kris Clippeleyr — Tue, 10 Jan 2006 06:49:17 GMT

Geir,
Got this (=attachment) a while back from the net (don't know where exactly).
According to the comments, the algorithm is by Rick McCarty.
It seems to do what you want.
Have fun,
Kris (aka Qkcl)

Re: Calculate weeknumber with a DCL-script

Paul Jerrom — Tue, 10 Jan 2006 20:02:57 GMT

Presumably the answer would depend on how you define the first week of the year. Ian's answer above would give Sunday 1st Jan-Saturday 6th Jan as week 1; the ISO answer says 1st Jan was week 52 of last year. Next year Ian's answer would be Monday 1st Jan-Sunday 6th Jan.
Other definitions of week 1 would be the week that contains Jan 1; the week that contains the first Monday of the year; or the first week that contains a majority of days in this year.
So probably best that you define in words what your definition of the first week of the year is, then doubtless someone will come up with a bit of DCL for you!

Have fun,

PJ

Re: Calculate weeknumber with a DCL-script

Jan van den Ende — Wed, 11 Jan 2006 04:42:17 GMT

Paul,

see the attachment by QKCL for the official ISO definition.
The week (monday though sunday) containing the first THURSDAY of the year is defined to be Week 01.
And if you wonder how they got to THAT definition: they probably were utterly drunk and at the same time using some illegal hallicinogens at the same time!

hth.

Proost.

Have one on me.

jpe

Re: Calculate weeknumber with a DCL-script

Joseph Huber_1 — Wed, 11 Jan 2006 08:04:20 GMT

Jan, no , they were just (too?) sober: the Thursday rule makes sure week 01 contains at least 1 working day.

(Although I admit it is true for western culture only, where Sat./Sunday is the weekend).

Re: Calculate weeknumber with a DCL-script

geir_2 — Wed, 11 Jan 2006 08:13:37 GMT

Hi,
Thanks to all. :-)

Re: Calculate weeknumber with a DCL-script

Martin Vorlaender — Wed, 11 Jan 2006 09:23:30 GMT

Jan,

the thursday rule is equivalent to "week containing at least 4 days" or "majority of days in the week".

cu,
Martin

Re: Calculate weeknumber with a DCL-script

Martin Vorlaender — Wed, 11 Jan 2006 09:25:39 GMT

Jan,

"week containing the first thursday" is equivalent to "first week containing at least 4 days" or "first week with a majority of days in the week".

cu,
Martin

Re: Calculate weeknumber with a DCL-script

Jan van den Ende — Wed, 11 Jan 2006 09:35:51 GMT

Martin,

ok, that explains it a bit better than the official text!

Tnx.

Proost.

Have one on me.

jpe