LASTDELETEDATE

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

LASTDELETEDATE ( <table_name> )

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

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

LASTDELETEDATE(INDIVIDUAL)