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"