FMPro11 and Mac 10.6
Before I waste hours, I would like to know if it is even possible to produce a small Portal which displays, let’s say, 5 next items due. For example, on 1st May, the Portal would display: First Item 5th May, Second Item 14th May, Third Item 10th June, etc. On 6th May, the 5th May item would move to the end of the list and out of sight, i.e. the list would sort automatically and daily so that the next item due is at the top.
Some items would renew annually e.g. Insurance, and others may be one offs, e.g. Appointment.
If this Portal is possible, I would appreciate a few pointers. In particular, how would the Portal sort or update daily? Also, what would be the best way to deal with the dates which would generally not require the year included?