I have a string column with a datetime in it, I want to drop the time and reformat the column to date format. In field calculator I type:
to_date( (EndDate), 'yyyy/MM/dd')
This gives the following error:
Eval Error: Cannot convert '2020-07-15 15:12:55' to Date
How do I manage this?