Mark records within Nth days of todays date

Build your list of AccuZIP6 commands by requesting commands and sharing commands with other users

Moderators: Chrissy, Steve, Terry, Donna, Dave, Eric, MartyH, Kristen, Geoff, Vince

Post Reply
User avatar
Dave
Site Admin
Posts: 620
Joined: Wed Sep 20, 2006 3:20 pm

Mark records within Nth days of todays date

Post by Dave » Fri Jul 03, 2009 8:49 am

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

Code: Select all

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

Post Reply