CREATE TABLE table_name_47 (opponent_in_the_final VARCHAR(255), date VARCHAR(255))
On October 14, 1996 who was the opponent in the final?
    
SQL: SELECT opponent_in_the_final FROM table_name_47 WHERE date = "october 14, 1996"