It would be useful to have a criteria option for "Week-to-date" for dates when creating queries, similar to how there is also a month-to-date, year-to-date, and even a quarter-to-date option. This would eliminate some of the tedium from daily processes.