Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations strongm on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

finding dates within 30 days 2

Status
Not open for further replies.

rcreed1

Technical User
May 20, 2004
36
US
Hello,

I have created a database to keep track of soldiers here in Korea. I have a query that finds soldiers who are scheduled to leave (Korea) in 30 days. It uses this...

Between Date() And DateAdd("d",30,Date())

It works great but I realize that if that soldier is not erased from the database and their date of departure has already passed the query does not display their info.

How can I change this equation so if today's date (for example) is....
11 AUG 2004 and the date in their file is 01 AUG 2004 their info is still displayed when the query is run?

Thank you for any help you can provide.

SFC Reed
 
And what about simply this ?
<= Date() + 30

Hope This Helps, PH.
Want to get great answers to your Tek-Tips questions? Have a look at FAQ219-2884 or FAQ222-2244
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top