Please enable JavaScript to view this site.

Vernon CMS Help

Purpose/Function

Return the 'last' Related Activity record, i.e. the record with the closing date that has most recently passed.

Argument syntax and parameters

LAST.ACT!arg2!arg3!

arg2

Required

The System ID of the Related Activity file.

arg3

Optional

This parameter can be used to exclude records that ended more than a certain number of days ago.

If this parameter is not specified, the most recently ended Activity will be returned.

Parts of the argument are delimited by an exclamation mark.

Example:

LAST.ACT!LO!365!

In this example, the most recently ended Related Outward Loan (LO)record will be returned, but only if the End Date was less than 365 days ago.