CREATE TABLE table_1329532_2 (date_of_election VARCHAR(255), appointed_successor VARCHAR(255))
What was the election date for H. Brent Coles?
    
SQL: SELECT date_of_election FROM table_1329532_2 WHERE appointed_successor = "H. Brent Coles"