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.