A handy list builder field for last updated date

We had a request from our Development department to be able to schedule a Full Bio based on a list of anyone updated in past week.

This required a new list builder field to be able to check on records update in the last week.

We created a new List Builder field in T_KEYWORDS as follows:

Description:   Last Updated (from Audit Tbl)

Data Type:   Date

Edit Mask:   Date

Detail Tbl:   TA_AUDIT_TRAIL

Detail Col:  max(!.date)

 

Hope this info is of help to someone else.