Pull data from today back one year 2

[ado2002]

Hi,

I would like to know if there is criteria that I can use to gather data for today and exactly one year prior. I have tried the <=now(), but it gives me everything prior to today. I need to narrow it down to only one year's worth of data.

Thank you in advance.
Anjie

 

[thecreator]

Have a look at the DateDiff function to calculate a date exactly a year ago ....

Hope this helps

 

[cheerio]

try Between DateAdd("yyyy",-1,Date()) And Date()

Avoid the now() function unless you really want to take the time of day into account. The date() function gives today's date without a time of day.

 

[scottian]

how could this be done if i wanted to deduct 1 month?

Be ALERT - Your country needs Lerts

 

[EliseFreedman]

try
DateAdd("m",-1,Date())

HTH

Elise