Schema: CREATE TABLE table_name_40 (date VARCHAR, loss VARCHAR)
Question: On what date was the Loss by Flanagan (6-7)?
SQL: SELECT date FROM table_name_40 WHERE loss = "flanagan (6-7)"