GetNthRecord, when used to refer to a related table, will return the specified related record such as the 2nd, but you can also set up a sorted portal, sorted by date in descending order and sized to display only two portal rows. This will then list the most recently dated pair of related records also.
I know that Last (Portal:Field) will get me the field info on the last portal row. what about getting the info on the 2nd to last portal row?
I'm trying to get a date and whenever i type Last (Portal:Date Field) -1, it just takes off a day from the date instead of giving me the 2nd to last portal eow result.
Do you want the 2nd related record or the 2nd to last? From your original post, I suggested a method that makes the record you want the 2nd record every time.
getNthRecord ( RelatedTable::Field ; 2 )
will return the value of Field from the 2nd related record.
GetNthRecord ( RelatedTable::Field ; Count ( RelatedTable::neveremptyfield ) - 1 )
will return the second to last related record.