Change imported dates' format
I have imported a bunch (over 200) files from another data source and in the date field, the date is displayed like: "2-Jun-2009." I would like all of the dates in those fields to be changed to the format: "6/2/09," as filemaker doesn't seem to be able to make sense of and sort the above expression. Any ideas would be appreciated. Thanks.