Field Modification Custom Function

[rugby19852000]

I know that it is easy to note when a record was modified and who modified it, but I would like to do it at the field level.

For example, I have a field called "NextRentBump" and I want to make a field "NextRentBumpMod" that would calculate the last date that the field "NextRentBump" was modified.

I have a lot of fields I want to track, so creating related records for each field seems like a poor way to accomplish my goal.

I have been experimenting with this custom function:

Let (

trigger = fieldName

;

Get ( CurrentDate )

)

But it will enter the current date in all "NextRentBumpMod" fields that are referencing a "NextRentBump" that has data in it. This will update across all records each time any "NextRentBump" is modified.

I would like it to only update the related "NextRentBumpMod".

Thanks in advance for your help & please let me know if I am not being very clear above.