Dave, I have a client who does a variation on this. They batch all their invoices by week, 1 - 52. They simply use a column in their Invoice table that has 200152 or 200101 in it. This allows them to get the groupings they want. They can force stuff into one week or another and so it's not date dependent. It seems to work well for them.
Would something like that work for you? Not a lot of complexity to my client's method but it gets the job done. Scott ==== David Ebert wrote: > 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 -- Scott ==== Scott J. Salisbury Matrix Data Systems / The R:Street Journal 5114 Point Fosdick Drive NW, Suite E-272 Gig Harbor, WA 98335-1733 E-Mail Address: [EMAIL PROTECTED] Temporary URL: www.seanet.com/~sjs (downloads available) New Web Address: www.rStreetJournal.Com Direct Line: 206-423-7679 Toll Free: 888-386-5040 Seattle: 206-448-7975 Fax: 305-425-0491
