Mark records within Nth days of todays date
This command will allow you to mark or fill records if a date type field in your database is within Nth number of days of today's date.
NOTE
**AFTER=BETWEEN(ENTRY_DATE,DATE(),DATE()+7)
**BEFORE=BETWEEN(ENTRY_DATE,DATE()-7,DATE())
Copy and paste the following code in the Edit>Commands screen then click RUN
REPLACE X WITH "X" FOR BETWEEN(ENTRY_DATE,DATE(),DATE()+7) OR BETWEEN(ENTRY_DATE,DATE()-7,DATE()) |