Sorting records using Date plus another variable
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.
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?