Users may want to find constituents who have both active and lapsed memberships that have a specific Expires on date
1. Create a new constituent query 2. On the criteria tab select Membership, Current, Standing one of Active, Lapsed* AND Expires on equals specific date 3. Mark the Each record must meet all specified criteria checkbox.