Thread Rating:
  • 0 Vote(s) - 0 Average
  • 1
  • 2
  • 3
  • 4
  • 5
Compute week number.
#8
There are three ways to calculate a week number:

1) The first week has the first day in it and ends saturday. Then the next
     weeks are just Sundays to Saturdays. (OOPS! edited)

2) The first week starts on the 1st and ends on the 7th. This makes the 8th
     part of the second week.

3) ISO skips the first week if the first day is on a Thursday or later.

So, besides ISO, which way do you want it calculated? Sorta like "rounding".
Get my QB demonstrator here: http://dl.dropbox.com/u/8440706/Q-Basics.zip
Reply


Messages In This Thread
Compute week number. - by Moneo - 07-06-2008, 05:39 AM
Re: Compute week number. - by Clippy - 07-23-2008, 05:03 AM
Re: Compute week number. - by Moneo - 07-24-2008, 07:39 AM
Re: Compute week number. - by Clippy - 07-25-2008, 01:14 AM
Re: Compute week number. - by Moneo - 07-25-2008, 06:07 AM
Re: Compute week number. - by Clippy - 07-26-2008, 12:08 AM
Re: Compute week number. - by Moneo - 07-27-2008, 11:46 PM
Re: Compute week number. - by Clippy - 07-28-2008, 11:29 PM
Re: Compute week number. - by Moneo - 07-29-2008, 05:05 AM

Forum Jump:


Users browsing this thread: 1 Guest(s)