date query

[fishqqq]

Can someone suggest how to take a date field and search for all
records that are => 3 months from today?

i'm not sure how to handle this and the expression help doesn't have
an example of this either.
thanks
Steve

 

[KARL DEWEY]

Between Date() AND DateAdd("m", 3, Date())

 

[John W. Vinson]

Can someone suggest how to take a date field and search for all
records that are => 3 months from today?

There is no => operator. Do you mean all records between today and three
months in the future? all records later than three months in the future? or
something else?

i'm not sure how to handle this and the expression help doesn't have
an example of this either.

For all records later than three months from today (i.e. June 2, 2009 and
beyond) use a criterion on the date field of

 

[KC-Mass]

Try This:

In a query test for ">=DateAdd("m", 3, Date)"

Regards

Kevin