Hi Mike,

You can calculate a calendar week from any arbitrary date. For example

ldSunday = {^2000/01/02}
lnWeek = INT((ldDate - ldSunday) / 7) + 1

>
>Without resorting to some looping code, I'm trying to meet a business rule. If a person works different shifts in a single calendar week, they pay dues once for that calendar week.
>
>

>Start        End
>2007-12-02 2007-12-02 <- 2007 week 49 to 2007 week 49
>2007-12-04 2008-01-02 <- 2007 week 49 to 2008 week 1

>
>So I want to include only the second record because the 1st week is already accounted for in the second record.
>
>Further, is there no way to express weeks as a number that spans several years to simplify subtraction?
>
>Thanks