4 Replies Latest reply on Mar 22, 2010 10:49 PM by comment_1

    How to convert DD/MM/YYYY HH:SS to MM/DD/YYYY

    davidmccreary

      Title

      How to convert DD/MM/YYYY HH:SS to MM/DD/YYYY

      Post

      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). 

       

      Thank you.