Query with specific date range

[ickman]

I am trying to create a query that will pull information for a specific date and will include info for the next thirty days after that date.

Basically what I need is information=infoDate + 30 days


I hope I am making myself clear any help would be appreciated.

 

[Cagliostro]

use where DateDiff(d,onedate,otherdate)<30 John Fill

ivfmd@mail.md

 

[tlbroadbent]

In MS Access the query could be formatted this way.

Where MyDate Between InfoDate And Dateadd(&quot;dd&quot;, 30, InfoDate)

If you use the query designer you would put the following in the criteria.

Between InfoDate And Dateadd(&quot;dd&quot;, 30, InfoDate)

Between is inclusive so the query would select record with MyDate=InfoDate, MyDate=InfoDate+30 and all dates between. Terry

http://members.home.net/tlbroadbent/index.htm