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