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.

Outcomes