Filtering to show only last records in a Portal
Does anyone know a way that I can filter to show only the last records in a portal. I have a database where the Parent table creates records in the child (portal) table on a regular basis, however only the most recent are really relevant. Data is also entered into the Portal so eventually it's going to be a bit of a bind scrolling through the portal to get to the bottom. The records have both id (serial number) and date fields but all of my calculations seem to fail.
I thought date field+365>get(currentdate) would show what I wanted but it still shows all.