1 Reply Latest reply on Dec 12, 2012 12:36 PM by philmodjunk

    Sorting records using Date plus another variable

    I.T.guy

      Title

      Sorting records using Date plus another variable

      Post

           I would like to have my records be automatically sorted and displayed based upon a given duration of time (ex. Days or weeks).

           Example. I will create a new record with today’s date. I would like to tell FM-Pro to find all records with the same date plus the amount of weeks or days that I determine when saving the record. This duration can be a drop down, or a calendar within the record. However, not all records could have the same duration.

           Any help would be appreciated.

            

        • 1. Re: Sorting records using Date plus another variable
          philmodjunk

               Picky detail: You are finding records, not sorting them.

                So if today is 12/12/2012 and you had the following records:

               12/12/2012     3 days
               12/11/2012     4 days
               12/10/2012     2 days
          12/10/2012     1 days
               12/01/2012     11 days

               Your find should find all records except the one in red?