AnsweredAssumed Answered

Script to find records older than 30 days

Question asked by ToddGetz on Aug 14, 2013
Latest reply on Aug 14, 2013 by ToddGetz


Script to find records older than 30 days


     I am trying to write a script to perform a quick find for all records 30 days or older from the date of creation, and exclude those marked as previously found.  These are my fields:

     DatePulled = date the record is created
     Destroyed = previously found, is a checkbox where checked is equal to 1

     I tried to first right the find records older or equal to 30 days as:  
     DatePulled ≤ (Get ( CurrentDate )-30)

     I just cannot get this to work. Until this works I cannot even begin to figure out how to exclude the records with the checkbox marked.