How to convert DD/MM/YYYY HH:SS to MM/DD/YYYY
Filemaker 8.5 on Mac OSX 10.4.11. I have 900 records imported from a SQL dump, imported into filemaker but the timestamp field is DD/MM/YYYY HH:SS
I need to sort records by date, but it sorts by the first two digits. How do I either get it to sort by date whilst leaving current formatting intact (I'd prefer to not alter something OS-wide on the computer if that's a solution) or change that format to MM/DD/YYYY ( I don't care about the HH:MM fields).