AnsweredAssumed Answered

I need help finding matching fields on each record

Question asked by cmilton1 on Jan 24, 2019
Latest reply on Jan 31, 2019 by comment

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.