I have a field in my Table called "DetailValue". This field is used to store a variety of date (including dates, text etc).
I need to find all values in this table that are dates (in the form of dd/mm/yyyy), and then convert them to the form yyyy-mm-dd.
How can I do this?????