i tried to load my data and somehow the column with date type date has swaped the value of year to day and day to year. is there any way i can swap them?

output

```
+------------+
| deadline   |
+------------+
| 2029-05-14 |
| 2019-01-18 |
| 2016-02-01 |
| 2023-10-14 |
| 2025-03-16 |
 +------------+

```

also I loaded the data as dd-mm-yy format.