Date Query question

D

David

I am trying to write a query that will give me 90 days from a certian point;
90 Days Out: DateAdd("d",-90,[ETS]), (ets is the date when someone is
leaving), this gives me all the days, but how do I write it so that I only
get days that are 90 days from the date they are leaving.
 
J

John Vinson

I am trying to write a query that will give me 90 days from a certian point;
90 Days Out: DateAdd("d",-90,[ETS]), (ets is the date when someone is
leaving), this gives me all the days, but how do I write it so that I only
get days that are 90 days from the date they are leaving.
Click to expand...

Do you mean:

Exactly 90 days, e.g. not 89, not 91, but only the 90th day

or

After 90 days have elapsed?

If the latter (as I guess) use a criterion of
= DateAdd("d", 90, [ETS])
Click to expand...

The -90 will find dates 90 days BEFORE the ETS date.

John W. Vinson[MVP]
 
W

Walter Steadman

David,
Based on the fact that you are using ETS, I am assuming you are in the
Army. What kind of DB are you trying to create? I too am in the Army.

Wally Steadman
US Army in Iraq
 
D

David

I am trying to work on a reenlistmen DB that would show me when a soldier is
90 days from their open window. I to am currently in Iraq, Mosul.

Walter Steadman said:
David,
Based on the fact that you are using ETS, I am assuming you are in the
Army. What kind of DB are you trying to create? I too am in the Army.

Wally Steadman
US Army in Iraq


David said:
I am trying to write a query that will give me 90 days from a certian
point;
90 Days Out: DateAdd("d",-90,[ETS]), (ets is the date when someone is
leaving), this gives me all the days, but how do I write it so that I only
get days that are 90 days from the date they are leaving.
Click to expand...
Click to expand...
 
Top