SCHEMA:
CREATE TABLE table_name_26 (record VARCHAR, date VARCHAR)
USER:
What was the record on September 4?

QUERY:
SELECT record FROM table_name_26 WHERE date = "september 4"