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
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