_dateparsefailure error despite appearing correctly

The first line containing headers will be the first event processed, and this should cause a _dateparsefailure, so you may need to drop this. You should be able to check if the first column contains the text DATE and then use a drop filter.