>Hi Mike,
>
>You can calculate a calendar week from any arbitrary date. For example
>
>ldSunday = {^2000/01/02}
>lnWeek = INT((ldDate - ldSunday) / 7) + 1
>
Yes! That should work very nicely. Thanks again!
>
>
>>
>>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