Hi Chris, just before we go any further. I am calling this query from my c# app, so the program checks the day @0700 and if its Monday that's when this query will execute, wouldn't it be easier to say enddate between 168hrs, if you understand

Jay