Search results

Hi pbaldy, Thanks for the welcome. I did not notice that it was an old thread. It did present as a highly relevant thread when searching for a solution so I thought it would be good to post a solution that gets around the issue of pushing a Sunday to the next week.

DATEADD("D", (8 - WEEKDAY(FinishedDateTime))MOD(7), FinishedDateTime) AS WeekEnding This is what I had to do to allow my WeekEnding query field to stay within the same week (finishing on a Sunday) when the FinishedDateTime value was a Sunday. The other methods kept pushing the weekending to the...