10 Replies Latest reply on Dec 6, 2009 1:53 PM by DRR

    Change imported dates' format



      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.