I have two tables, one contains projects with a start and end date as well as rows with numbers of people in certain positions that need to be assigned to the project and the other contains the assignments with a person reference and start and end date of said assignment as well. Essentially, a project has a start and end date and there can be multiple assignments to each position needed between those dates (many to one relationship).
In the project table, I need to iterate through all of the assignments for a row to determine whether or not I am missing assignments to a certain position within the project for any given whole week.
Theoretically, I should have no issues adding columns or tables to manage all of this. Also, this is within a paid account and so we do have the luxury of packs if there are any packs that can manage any of this.
In this example, I should be missing a human during the first week and last week of the project. I need the result to be an array of Monday dates.