5 Replies Latest reply on May 27, 2017 9:25 AM by philmodjunk

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

    argus2

      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?