CREATE TABLE table_name_22 (date_of_vacancy VARCHAR(255), manner_of_departure VARCHAR(255), outgoing_manager VARCHAR(255))
I wan the date of vacancy for departure of resigned and outgoing manager of gordon wylde
    
SQL: SELECT date_of_vacancy FROM table_name_22 WHERE manner_of_departure = "resigned" AND outgoing_manager = "gordon wylde"