CREATE TABLE table_1329532_2 (date_of_election VARCHAR, appointed_successor VARCHAR)

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