What are the dates of the outgoing manager colin hendry does appointments?
create table table_11207040_6 (date_of_appointment varchar, outgoing_manager varchar, PRIMARY KEY (date_of_appointment))
select date_of_appointment from table_11207040_6 where outgoing_manager = "colin hendry"