I can't think of the script steps to accomplish what I thought was a simple task.
I'm trying to search each record in a table in my database for the criteria where two fields match.
Specifically I want to find each record where the "SubscriptionStartDate" = "SubscriptionEndDate" and then insert a calculated result in the SubscriptionEndDate of "".
Does the Perform Find script step allow this condition. From what I can tell it does not.
I tried setting a variable for the Start Date but a subsequent Loop script step only works on the records with the value of the current record I initiate the script on.
Thanks in advance for any advice.