Mark when date field data is within 7 days of current 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
Eric
Moderator
Posts: 1909
Joined: Tue Sep 19, 2006 3:29 pm
Contact:

Mark when date field data is within 7 days of current date

Post by Eric » Wed Jul 01, 2009 4:06 pm

Here's a command that will mark the records in your list where the field named entry_date contains dates that are within seven days of the current date:

Code: Select all

replace X with "X" for date()-entry_date<=7
For this command to work properly, the entry_date field must be a Date type field. Pull down the Edit menu to Fields to check the Type.
Chat with an AccuZIP6 technician weekdays from 7-4 PST with AccuZIP6 Live Online Support

Post Reply