Date Query question

[Guest]

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.

 

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

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

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

John W. Vinson[MVP]

 

[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

 

[Guest]

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.

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

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.