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.