Table schema:
CREATE TABLE table_1329532_2 (date_of_election VARCHAR, appointed_successor VARCHAR)

Question: What was the election date for H. Brent Coles?
SQL: SELECT date_of_election FROM table_1329532_2 WHERE appointed_successor = "H. Brent Coles"