user: ### NOW ANSWER:
Question: On what Date was the Meet of 2007 Pan American Games with a Time of 1:07.78?
Columns: ['Event', 'Time', 'Nationality', 'Date', 'Meet', 'Location']
Types: ['text', 'text', 'text', 'text', 'text', 'text']
Sample row: ['50 m freestyle', '25.09', 'United States', '21 October 2011', '2011 Pan American Games', 'Guadalajara , Mexico']
SQL:

assistant: SELECT "Date" FROM "Table" WHERE "Meet" = '2007 Pan American Games' AND "Time" = '1:07.78';