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())

REPLACE X WITH "X" FOR BETWEEN(ENTRY_DATE,DATE(),DATE()+7) OR BETWEEN(ENTRY_DATE,DATE()-7,DATE())

« Back to Commands

New to the
Mailing
Industry?
More Info

Professional Services
More Info

You guys have indeed been great partners in aiding us with getting our mailings processed through your software and out the door. I want to say we’ve been with you guys for at least 12 years now, if not longer. Find something good you stick with it is how I see it.

P.H., Colorado Springs, CO