Hi,



I have a table with dates during which projects are reviewed (one ID column and one date column). I also have a table with project names and their team meeting date (different than review date). Both dates are immovable. I want to add a column to the project table assigning a review date depending on its team meeting date.

All projects that have a team meeting date between X and Y, where X & Y are project review dates, should be reviewed on project review date X, which is the project review date immediately preceding the team review date.

So for example, if the next two project reviews are 2/18 and 2/31, all projects that have a team meeting date between 2/18 and 2/30 (inclusive), will be reviewed on 2/18.

Any help will be greatly appreciated!
Thanks!