PENULTIMATEDELETEDATE

Using the table name supplied the function returns a date and time that represents the penultimate time that a delete action was carried out on the specified table. The function will return the same value for every record.

PENULTIMATEDELETEDATE ( <table_name> )

table_name: The table to retrieve the last deletion time from.

Example: Create a field on the INCOMINGREQUESTS table that indicates the penultimate time that record deletion took place.

PENULTIMATEDELETEDATE(INCOMINGREQUESTS)