3 Replies Latest reply on Mar 24, 2015 6:39 AM by chf

    Sort by Date



      Sort by Date


      I am having a problem sorting by date.  I have set it up so that the column header is a button, and when it is clicked, it sorts by that field.  It works perfectly when I click for every column, however, when I try to sort by date, it still sorts by the "stock number" field.  I checked the button, and it is says sort by "DOF" field, but then when I look at the actual sort button at the top of the screen, it says that it is sorted by stock number... I have made sure that the DOF field is set to "date", not "text" as well. 

      I have included a picture of what happens when I click on the DOF button to sort by that date.  In addition, the way this data is entered is by a drop-down calendar, so I don't know how the date format could be wrong.


        • 1. Re: Sort by Date

          If you select Sort Records from the Records menu and it does not show that your records are sorted by DOF, then they are not sorted by DOF.

          If you have FileMaker Advanced, select the script debugger tool and then click the column header to see what happens one step at a time. Only guess I can make from here is that maybe the entire blue background record is a button to sort by Stock number and so your mouse click may have "missed" the button to sort by DOF and clicked a button to sort by stock number.

          • 2. Re: Sort by Date

            You are completely right! The button for stock number extends way larger than the text box that actually says "stock number", so I was clicking that! I would have thought the button would simply take the place of the object.  Is there a way to change the size the button occupies?

            • 3. Re: Sort by Date

              Fixed it! It was a problem with the position locks.  Thanks again!