Re: Determine Week in Year

Hi James,

Thanks for the info -- that's at least one tidbit for me today from this
list. Even if they don't follow the ISO standards, they'd still have to
adjust for the starting day of the week.

BTW, looking at my year 2000 calendar, 1 Jan 2000 was a Saturday, so it
looks like 14 Jan 2000 actually was in the 2nd week using the ISO standards,
and in the 3rd week if not using ISO.

Regards,
Peter Dow
Dow Software Services, Inc.
909 425-0194 voice
909 425-0196 fax

----- Original Message -----
From: "James W. Kilgore" <eMail@James-W-Kilgore.com>
To: <MIDRANGE-L@midrange.com>
Sent: Wednesday, November 01, 2000 10:42 PM
Subject: Re: Determine Week in Year


> Richard,
>
> This is not workable.  ISO standards specify that week #1 is the first
> week that contains 4 or more days.  Now without getting into which day
> of the week you may consider the first day (Sunday like the more popular
> calendars or Monday like the rest of the calendars) You can have week #1
> have days 1,2,3,4 and week #2 has days 5,6,7,8,9,10,11 so in your
> example day 14 is in week #3, not week #2.
>
> Richard Reeve wrote:
> >
> > Scott,
> >
> >      I believe that if you were to convert the date to
> > julian and then divided the days (the last three
> > positions of the julian date) by 7 you would get the
> > week that the date fell in.
> >
> >      For example for julian date 00014 you would
> > divide 014 by 7 and find that the week was 2.
> >
> >      Hope this helps.
> >
> +---
> | This is the Midrange System Mailing List!
> | To submit a new message, send your mail to MIDRANGE-L@midrange.com.
> | To subscribe to this list send email to MIDRANGE-L-SUB@midrange.com.
> | To unsubscribe from this list send email to
MIDRANGE-L-UNSUB@midrange.com.
> | Questions should be directed to the list owner/operator:
david@midrange.com
> +---

+---
| This is the Midrange System Mailing List!
| To submit a new message, send your mail to MIDRANGE-L@midrange.com.
| To subscribe to this list send email to MIDRANGE-L-SUB@midrange.com.
| To unsubscribe from this list send email to MIDRANGE-L-UNSUB@midrange.com.
| Questions should be directed to the list owner/operator: david@midrange.com
+---