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.