I am trying to create Point In Time transactions and can't figure out the best way to do it. Here is the scenario:
Object 1 - Profile
Object 2 - Profile PIT (Point In Time)
Anytime a record in Object 1 gets added, I insert a new transaction into Object 2 (I have a connection). That works fine. I assign the Effective Start Date with the current date/time and leave the Effective End Date blank.
Next, if Object 1 gets Edited, I repeat the step above where I insert a new transaction into Object 2. However, I want to go back to the first record created in Object 2 and update the Effective End Date with the current date - 1.
There is no way to use the form rules to accomplish this from what I see. Any recommendations on how to accomplish this?
Thanks for any help you can provide.