I have a list of records that I would like to sort in ascending date order but the dates are entered into a free text field that is not formatted as date in the database. I therefore potentially have variations such as:
Furthermore, even if all dates follow the same format (e.g. dd/mm/yyyy), the report seems to only sort by the number before the first "/". So for example:
Is what I am trying to do possible so that it is sorted correctly?
Many thanks in advance