INTCK('week.4', ...) counts intervals where weeks start on Sunday (day 4). From Jan 1 to Feb 1 2010, there are exactly 4 complete week intervals: Dec 27-Jan 2, Jan 3-Jan 9, Jan 10-Jan 16, and Jan 17-Jan 23. Feb 1 starts a new interval but doesn't complete it.