AnsweredAssumed Answered

Problem Sorting records by date

Question asked by memt on Nov 4, 2009
Latest reply on Nov 5, 2009 by raybaudi


Problem Sorting records by date


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!