Hey all

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