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

The [Merge Fields feature]...saved me hours of having to do a bunch of manual address corrections in an updated database, that I already had done months ago on my original database. What a relief. Certainly Rolaids can't top this.

V.J., Los Angeles, CA