Date query

[snappl3]

I need to get a query to pull from my database any date 6 months or less into
the future (ex. The query would pull up any orders which have a date of
10/2/08 or sooner). Any help would be greatly appreciated. Thanks!!

 

[KARL DEWEY]

For criteria on your date field use this ---
<= DateAdd("m", 6, Date())

 

[Golfinray]

Put in the date criteria of your query Between 4/3/2008 and 10/2/2008.

 

[fredg]

I need to get a query to pull from my database any date 6 months or less into
the future (ex. The query would pull up any orders which have a date of
10/2/08 or sooner). Any help would be greatly appreciated. Thanks!!

As criteria on the date field, write:
Between Date() and DateAdd("m",6,Date())