Using the table name supplied the function returns the penultimate date and time that the specified table was subject to an update or append of records. The function will return the same value for every record.
PENULTIMATEUPDATEDATE ( <table_name> )
-
table_name: The table from which to retrieve the penultimate update date value.
Example: Create a field on the INDIVIDUAL table that shows the penultimate date and time the table was subject to an update or append of records.
PENULTIMATEUPDATEDATE(INDIVIDUAL)