I need to know if there is a standard for updating a datetime field that is not entered by the user. The purpose of the field is to document the time a record was updated. Is it better to update the field from the user interface or by creating an update trigger? Is there a different way to do this? Which way is the standard? Any other thoughts?
