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 >>
