I have a field called Last updated that contains the following type of date entry "10:51 - Monday 03 September 2018".
I need to break down the data into something sortable. Do I need to break it up into three fields (Time, Day, Date).
How can I do this?
PS I use Filemaker pro 11
Many thanks in advance