Greetings Jeff,

Thank you for your code adaptation to find the start of the week based on integer truncation. Definitely an interesting and faster way to find the start. After that - a simple matter of +7 to get the end. I would like to know though, would you consider it faster to use a "BETWEEN Start AND End" when organizing a series of records into week period sets or is there an easy way to also find the week period of the year as well? My considerations is that when working with timesheets, I usually want to group each person's set of timesheets into weekly periods for finding total hours. I usually am working with several million records so speed tweaks are always helpful.

It is always a joy to learn from others who know more than me and are willing to instruct in better ways.

Thank you for your time.

Terry Steadman