In my database I setup a date field which I like to only update if the address field has been changed or modified. I tried several formulas in a text field with no luck. I also searched the manuals and this community for some help without finding anything.
*** For now I want to copy the “created date field” into this date field if it is empty.
*** After that, I need a formula that updates this date field if the address has changed.
F2 is the “created date field” to be copied.
F21 is the “date field” when the address has been changed.
A21 is the complete address field
Some of my failed tries are as follows:
I haven’t tried any formula to update this field if the address has been changed.
Your help to create these TWO formulas would be much appreciated.