What version of FileMaker do you have?
It would seem a portal that either filters by expiry date (filemaker 11) or that uses a relationship that includes a filtering field for expiry date (older versions) should be able to display all records that have an expiry date within 5 days of the current date--to give an example.
thanks for the reply.
I use filemaker pro11.
I used the portal. this is connected to the table that I
interested. but it gives me no records.
the table of the portal is related
I do not understand where I went wrong
I found where was my mistake. I had not given the correct type of relationship!
But I now ask you can view the deadlines for various records in three different tables.
I do three or portals can have only one?
I make a note of the deadlines relating to records in multiple tables?
3 tables means three portals in most cases. It's possible to store the deadlines in a 4th, related table for all three tables so you can have just one portal, but that would take some additional design work.
You'd use a filter expression such as:
( Get(CurrentDate ) - 5 ) < PortalTable::ExpiryDate
To limit the records to only those whose expiry date is within 5 days of today.