Refresh time before editing record with current time using the now() method.

This question has been asked many times in this forum and has never really had a satisfactory answer.

But here is a low tech solution..

Instead of directly updating the date/time, use an Action or an Automation to set the current time. So the edit of a record will request that the date time be updated, rather than directly updating it.