Date Range Find Script
I created a project tracking database that has a FollowUp date field for when I need to get back to someone in the future as a follow up or task.
I would like to create a button that sits next to this FollowUP date field that when clicked will activate a find script that will find every date in that field that is within a +/- 7 day range of the current date. I am having problems formulating such a find script. Can some one please offer some script ideas to accomplish this?
See this thread for examples of scripted finds--including those that use a calculated date range such as:
Set Field [Yourtable::DateField ; Get ( CurrentDate ) - 7 & "..." & Get ( CurrentDate ) + 7 ]