The Next Gate of a project is the gate whose Workflow State is other than “Approved” and whose Finish date is the closest to Today’s date.