AnsweredAssumed Answered

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

Question asked by davidmccreary on Feb 20, 2010
Latest reply on Feb 20, 2010 by comment_1

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.

Outcomes