Show 0-30 days from Today

[Robb @ FLW]

I have a query with a start date and end date and they are date/time fields
it is set up dd/mmm/yy format.

What I am looking to do is in a query have it find dates that are 0-30, days
from todays date

example
field has the date of 1 June 08, I want the query to show the dates that
fall with in < 30 days of 1 June 08 so I will see from 2 May to 1 June dates.

 

[Golfinray]

Number of Daysatediff("d",[onefield],[theotherfield])

 

[raskew via AccessMonster.com]

Robb -

Use the DateAdd() function, e.g.

? dateadd("d", -30, "1 June 08")
5/2/2008

HTH - Bob

 

[KARL DEWEY]

I am not sure of what you are asking but I think this is it --
Between Date() And Date()+30

 

[Ron2006]

Or

between date()-30 and date()


depending on which way you are looking....

Ron

 

[Ron2006]

If the date you are comparing against is really a date and time stamp
(has a time aspect to it) then



between date() and date() + 1


or

between date()-30 and date() + 1

will be what you need to get today's activity or the 30th day's
activity back.

Ron