Never mind this. It would exclude records from previous or next year
which fell within the
start-close window.

> There is another field I can use to further limit M2:
>
> JOIN MEMBERS M ON M2.ID = M.ID AND M2.YEARM2 = EXTRACT(YEAR FROM
> current_date) AS YYYY