Retrieve Records for the Past Year

[depawl]

I trying to create a query that just returns all of the records in my database for the past year. I've tried to somehow do it using the date() function but haven't had much luck yet.
Any help is most appreciated.

 

[pbaldy]

There are some date functions here that should prove useful:

http://www.pacificdb.com.au/MVP/Code/Dates.htm

 

[raskew]

Try these in the criteria cell of your date field:

For a full year back from today's date:

between dateadd("yyyy", -1, date()) and date()

For the current year:

between dateserial(year(date()),1,1) and date()


HTH - Bob

 

[depawl]

Thanks guys. As far as I can see right now, this function in the criteria of the date field seems to work:
>Date()-365
Appreciate the help.
Dennis