Re: To_char ('IW') format element

From: Randy Harris <randy_at_SpamFree.com>
Date: Wed, 19 Jan 2005 23:40:05 GMT
Message-ID: <pdCHd.11142$Vj3.1222@newssvr17.news.prodigy.com>

"Randy Harris" <randy_at_SpamFree.com> wrote in message news:LWBHd.11135$Vj3.736_at_newssvr17.news.prodigy.com...
> I'm looking for clarification of the 'IW' format element. The docs say it
> is based on the ISO standard, but I haven't been able to find further
> information. It's rather obvious if Jan falls on a Monday, week 1 begins
> the same day. But, what if Jan 1 falls on a Tuesday? Does week 1 begin
> that day, or the following Monday?

I'm finding it tough to figure this out by trial and error. It is looking as though week 1 always begins on Jan 1 and week 2 begins the following Monday - except - if Jan 1 is a Friday, Saturday or Sunday, then week 1 doesn't begin until the following Monday and week 2 begins on the second Monday.

Can anyone confirm that this is correct? Received on Wed Jan 19 2005 - 17:40:05 CST