The time manager in Qgis demands date in YYYY-MM-DD format. I have a large text file with the dates in DD/MM/YYYYY format. It's too large to manually change format. Is there any way of automating this process? I have tried altering format in Libre office but it still stays the original format.The date format required is 2020-01-16. Human name fields removed.

```
Record ID   English Name    Grid Reference  Latitude    Longitude   Site Name   Abundance   Record Type Date    Comments    Time of sighting    Squirrel ID Weight (g)  CRST Comments
7765235 Red Squirrel    SJ0369952368    53.059853   -3.4384031  Clocaenog: Bron Branog: Location 10 1 Adult     01/10/2020      13:09           
7765230 Red Squirrel    SJ0367552319    53.059408   -3.4387464  Clocaenog: Bron Branog: Location 9  1 Adult     01/10/2020      16:54           
7761554 Red Squirrel    SH9856552277    53.058084   -3.5149526  Clocaenog: Pentre-llyn-cymmer: Location 5   1       01/10/2020      17:22           
7761417 Red Squirrel    SJ0454252299    53.059384   -3.4258081  Clocaenog: Main Block East: Location 15 1       01/10/2020      16:36           
7761416 Red Squirrel    SJ0454252299    53.059384   -3.4258081  Clocaenog: Main Block East: Location 15 1       01/10/2020      08:51           
7765217 Red Squirrel    SJ0357152125    53.057646   -3.4402395  Clocaenog: Bron Branog: Location 7  1 Adult     02/10/2020      13:42           
7765210 Red Squirrel    SJ0354052072    53.057164   -3.440686   Clocaenog: Bron Branog: Location 5  1 Sub-adult     02/10/2020      16:07           
7765209 Red Squirrel    SJ0354052072    53.057164   -3.440686   Clocaenog: Bron Branog: Location 5  1 Adult     02/10/2020  Patchy squirrel 13:54   

```