Unanswered: Identifying consecutive weeks in Report
I'm trying to create a report that is able to identify employees who worked at least 4 consecutive weeks of at least 20 hours within a 6 week period.
The user of the report indicates via parameter the pay period end dates, and I would like to be able to assign a variable the week ending dates (each pay period has two week ending dates)
What I tried was to create 6 variables, ppweek1 - ppweek6, and attempted to assign the week ending dates to them through a for loop. My formula writing skills are south of atrocious, so I'm hesitant to display what I tried.
Does anyone have any insight on how to best do this?