Group by week with a specific starting time

[FactoryMan]

I have a manufacturing database that I need to group by weeks.
I have been successful in grouping by weeks: PROD_TIME By Week: Format$([Copy of Query].[PROD_TIME],'ww',1,2)
However my weeks start on Monday at 8:00 AM.
How do I group by weeks with the week starting on Monday at 8:00 AM?


Each record has a date/time field mm/dd/yyyy hh:mm:ss.

I am pretty much a novice at this.

[June7]

Did you try setting the FirstDayOfWeek argument to Monday?

[FactoryMan]

Did you try setting the FirstDayOfWeek argument to Monday?

Thanks for the question.
Yes I did. I have no problem with my week groups starting on Monday the issue is how do I set the week to beging at 8:00 AM on Monday.

[June7]

That's a new one! Midnight to 7:59:59 each Monday morning should be in the previous week? Are there actually records within that time range?

Try:

Format$([Copy of Query].[PROD_TIME],'ww',1,2) - IIf(Weekday([datefield])=2 AND [PROD_TIME]<#8:00:00 AM#, 1, 0)