Due date to week number

At 12:20 PM 9/12/2001 , you wrote:
>I am looking for suggestions on how to convert reqduedate to the
>corresponding week of the year and group on each week w/o having to make a
>52 line formula in

Dates are just whole number count of days relative to a fixed point. So
you can do most mathematical functions on them.

Basically, it would be:
Integer( (MyDate - DayBeforeFirstPeriod) / NbrDaysPerPeriod ) + 1

Or for week long periods starting 1/1/2001:
INTEGER((TranDate - 12/31/00) / 7) + 1

'Course, you could simplify by adjusting the start date and eliminating the
+1. But it would be that much more confusing when you have to update it
next year.

-Wayne
Good Morning all,
I am looking for suggestions on how to convert reqduedate to the corresponding week of the year and group on each week w/o having to make a 52 line formula in RB.
Any suggestions will be appreciated.
Thanks
Dennyd


[Non-text portions of this message have been removed]