Finding dates in the future

Neil_Pattison

Registered User.
Local time
Today, 23:23
Joined
Aug 24, 2005
Messages
73
I have a table that holds the info on our fleet of company vehicles. One of the fields in the table is called ServiceDueDate. I want to be able to set up a query that shows any vehicles that have a service due in the next 30 days.

I know I'll need to use DLookup in there as well as Date - 30 but not sure exactly how to write the query.

Any help would be greatly appreciated.
 
In the criteria for the date field, type >Now() and <=Now()+30
 
I would use Date() rather than Now() since you don't really need the time and DateAdd() might be preferable if you want dates in the next month, rather than the next 30 days.
 

Users who are viewing this thread

Back
Top Bottom