LASTUPDATEDATE

Using the table name supplied the function returns the last date and time that the specified table was subject to an update or append of records.

LASTUPDATEDATE ( <table_name> )
  • table_name: The table from which to retrieve the last update date value.

Example: Create a field on the INCOMINGREQUESTS table that shows the last time the table was subject to an update action (i.e record append or updates).

LASTUPDATEDATE(INCOMINGREQUESTS)