Query to find records from 1 year ago

[Zorro1265]

I need to make a query that will show all results from 1 year from today + or - a week. Any thoughts? Zorro

 

[OldTom]

Hi Zorro

If you put >=DateAdd("yyyy",-1,Date()) in the criteria field of your date query, that will limit the records to the last year.

You can do similar things with the other options of DateAdd

Hope this helps a bit

Regards
Tom

 

[gol4]

between dateadd("d",-7,Dateserial(year(date())-1,month(date()),day(date()))) and dateadd("d",7,Dateserial(year(date())-1,month(date()),day(date())))

 

[gol4]

This will give the same
Dateserial(year(date())-1,month(date()),day(date()-7)) and Dateserial(year(date())-1,month(date()),day(date()+7))

 

[r937]

what about something a little easier to read

where now()-thedate between 358 and 372

for plus or minus a week


rudy

http://rudy.ca/

 

[Zorro1265]

Thanks gol4, I tried the first option you gave me and it worked great. I couldnt get the other 2 to work but one is all I needed. Zorro