5 Replies Latest reply on Nov 5, 2009 12:57 AM by raybaudi

    Problem Sorting records by date

    memt

      Title

      Problem Sorting records by date

      Post

      I am using Filemaker Pro 8 for Windows. I am currently trying to sort a find of some 200 records by the date the records were approved. I have all of my dates in the mm/dd/yy format.  When I try to do a sort by the dates Filemaker sorts by the first set of numbers, ie the month instead of by the year. I am then having the same problem when I export the list to Excel. If anyone has an answer I will be incredibly relieved.

       

      Thank you!