When did these failures occur?
SELECT T1.date_of_completion FROM Student_Course_Enrolment AS T1 JOIN Student_Tests_Taken AS T2 ON T1.registration_id   =   T2.registration_id WHERE T2.test_result   =   "Fail"
failures refer to test_result = 'Fail'; when did these occur refers to date_of_completion;