AnsweredAssumed Answered

Create script to Find records (x number of days ) old.

Question asked by argus2 on Apr 23, 2017
Latest reply on May 27, 2017 by philmodjunk

As simple as this sounds, I don't have it working like it should. I have created this script to find records 90 days old or more:

Screen Shot 2017-04-23 at 11.08.34 AM.png

This does what it's asked to do but I need to narrow the find results even more by checking two values from a drop down list called "StatusCheck".

... so I added a find modification...

Screen Shot 2017-04-23 at 11.19.58 AM.png

Again, this heads in the right direction and finds all records over 90 days where "StatusCheck" equals "sent for approval", but it doesn't allow me to add a second "AND"... (such as "StatusCheck" equals "waiting for FTO"):

Screen Shot 2017-04-23 at 11.34.46 AM.png

I tried adding both criteria in the same box but my method gets syntax errors. Is there a better way to create a script that would accomplish this?

Outcomes