Query to display expiration dates for next 30 days

Design by Sue

Registered User.
Local time
Today, 03:01
Joined
Jul 16, 2010
Messages
816
My database keeps track of training for employees, some of which expires after a period of time, which is in the tables. I need to create a query that displays only the employees and the training that expires during the next 30 days. I have a query that displays the expiration date (this field uses DateAdd and adds the expiration term to the date the employee completed the training) I am trying to add a criteria to this field. I found <=Date()+30 in my searches but that displays all of the records from 12/14 and back. I have tried all kinds of versions of this (obviously, not the correct one) and either get all records or none. (Yes there are records in the database that fall within the the period I am trying to display - that is something that I have been known to forget)

Is it because I am using criteria in a field that is based on DateAdd or what would be the correct criteria for this?

Thanks
Sue
 
How about

Between Date() And Date()+30
 
That was what I needed. Thank you!
 

Users who are viewing this thread

Back
Top Bottom