You don't really need DAY(7) at the end [that could give you the wrong result in some circumstances] - better to just use 7