Need help in trigger

[bookish]

Hi everyone, this issue is quite new to my newbie programmer mind.
I need to know when the fields related to payment are updated (UPDATE4FAO), but not when non-payment fields are updated.
My formula works only for the first time that a date of payment is updated. But after than since the condition is already met, the update field is updated too. 
P.S. Please don't mind the concatenation for date. In the real table I have a date/field field for UpdatePayment field.

[CoopperBackpack]

Hello @bookish,

As far as I understood you need to stamp the time when the specific field is updated.

The basic approach to track the changes is:

1) To join the Table and the #inserted table on the unique field.
This is needed to identify the record that is being updated.

2) To compare the previous value and the new(updated) value. If they are not equal, this means that the value was updated.

For example, the 'Update_Date' field will be updated when the 'Name' field is changed. 

 

Could you clarify this part 'but not when non-payment fields are updated'?

In my understanding, the field you are interested in can be updated along with the other fields. So, if you only need to track the change in the specific field regardless of the other fields, the example on the screenshot should work.

Feel free to ask questions if you need further assistance on this. 

[bookish]

Thank you @CoopperBackpack.

It seems logical but it did not work, unfortunately. I put a date in DateField an d there was no date/time that appeared in the field Update4FAO.

Regarding "but not when non-payment fields are updated'" I am referring to the same record. Day 1, in that record, the field DatePaid was updated, Day 2 the re was an update in the same record for contact number. In my initial screenshot, the field Update4FAO was updated in Day 1. But in Day2 it was also updated. I only wanted the field Update4FAO to be updated when there is a change in DatePaid.

[bookish]

HI @CoopperBackpack,

I want to update you that the trigger worked if the value I am updating is not a date but the mode of payment. (As to why it did not work for the DatePaid field, I will think abou that later. Here is my revised trigger.  Thank you very much!

[CoopperBackpack]

Hello @bookish, it is good to know that it works. I think I didn`t get all the details to understand the workflow. 
The main thing is to understand how to identify the updated record (join the tables on a unique field) and to compare the old and the new values. So, it is important to understand which values should be compared.