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

I understand why the USPS needs to change things over time, but since they don't have to deal with customers' software they often don't care about the downstream effects. You guys do a great job on both fronts.

J.P., Greenville, NC