Re: Timestamp problems...wrong weeks.

[Jean-Luc Lachance <jllachan@sympatico.ca>]

Personnaly, I think this use of W is useless -- anybody can dewide the 
day of the month by 7.  A more appropriate use of W might be for the 
week number to start with the first week with ALL dates in the month. 
An alternate interpretation might be to start with the first week that 
has at least one day in the month. The next issue is do you start the 
week on Sunday, Saturday or Monday...

JLL


Andrew Sullivan wrote:

> On Thu, Apr 29, 2004 at 02:42:49PM -0400, Campano, Troy wrote:
>
> > This is causing my reports to print out incorrect data.
> > Do you know why this would happen? Am I doing something wrong?
>
>
> I think you may be misunderstanding what "W" means:
>
> week of month (1-5) (The first week starts on the first day of the
> month.)
>
> In April 2004, 1 April is Thurs, so
>
> 1-7 -> W1
> 8-14 -> W2
> 15-21 -> W3
> 22-28 -> W4
> 29-30 -> W5 == W1 of May
>
> This is also why 8 May is in week 2 of May, but 7 May is on week 1.
>
> A


---------------------------(end of broadcast)---------------------------
TIP 7: don't forget to increase your free space map settings