G'day, Like Troy, I've gone the table route on this one.
I have a table called WE_WK_BP in the database (week ending, no of week in year, bonus period) that I populate for the next 20 years for a new client as well as giving them the ability to add, modify the data.. I supply the text files for each day of the week so if they change their week ending day at some point they can update the table from the text files for all values past a nominated start date. I anyone wants the text files and code drop me a line. At 03:14 PM 11/10/2001 -0600, you wrote: >To do these types of reports, I build a table that has: >The date - 1/1/01, 1/2/01.... >Week Num >Month Num >Day Num >maybee qtr_num > >Write a small program that goew through and populates it for you going out 5 >years or so. > >Now, buld a view between you original table, link on the date, and group on >week num. > >Troy > >===== Original Message from [EMAIL PROTECTED] at 10/11/01 1:33 pm > >I seem to remember a convention that week 1 of a year contains the first > >Thursday of the year. I don't know why. > > > >Bill Cook > >Kent WA USA > > > >----- Original Message ----- > >From: "David Ebert" <[EMAIL PROTECTED]> > >To: <[EMAIL PROTECTED]> > >Sent: Thursday, October 11, 2001 10:42 AM > >Subject: need an IWK > > > > > >> I've been asked to produce a report on an ongoing basis that reports, by > >> week for a given month, certain productivity stats. > >> > >> The weekly part has me stumped. The best I can think of is an > >> annually-updated 52 row table, but the "annually-updated" is a flop > >waiting > >> to happen. > >> > >> Can I say logically that a given date falls in week (n) in any given year? > >> > >> tia > >> > >> Dave > >> Warmest regards, Tom Grimshaw coy: Just For You Software tel: 612 9552 3311 fax: 612 9566 2164 mobile: 0414 675 903 post: PO Box 470 Glebe NSW 2037 Australia street: 3/66 Wentworth Park Rd Glebe NSW 2037 email: [EMAIL PROTECTED] web: www.just4usoftware.com.au This email and any files transmitted with it are confidential to the intended recipient and may be privileged. If you have received this email inadvertently or you are not the intended recipient, you may not disseminate, distribute, copy or in any way rely on it. Further, you should notify the sender immediately and delete the email from your computer. Whilst we have taken precautions to alert us to the presence of computer viruses, we cannot guarantee that this email and any files transmitted with it are free from such viruses.
