I have date field in a query that tracks an “action” due date. The goal is to get the action item completed, and closed before it becomes overdue. While I do have a “true” overdure report, it only details those records which are overdue. I need to create a report which will show me all records where the due date is from today and during the next 14 days. This way we can hopefully close these items before they show up on the overdue report. I have added the following criteria to the [DueDate] field in the Query, but it ends up returning all records that are 2-3 months from now, and not just those which fall within that 14 day “window”.
>Date()+14
Thank you in advance for your help.
