Hello
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:
dd/mm/yy
dd/mm/yyyy
d/m/yyyy
dd-mm-yy
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:
02/05/2019
05/01/2019
10/10/2019
23/09/2015
28/10/2016
Is what I am trying to do possible so that it is sorted correctly?
Many thanks in advance