I need to pull only the records in a table with a Due_Date field that have a due date of less than 7 days from the current date. Please help. Thanks.

Example: due dates are
01/07/01
12/17/01
12/29/01

I would want only the 12/17/01 record pulled.


[This message has been edited by lp4799 (edited 12-14-2001).]

In your query due_date field try
< Date()+7
HTH