Query 365 days or 12 months

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I need to write criteria to retrieve only the last 365 days or 12 months of
data from the standard date field (eg. 5/12/2004). This is probably easy for
most of you, but please indulge me... Thanks so much!
 
I'm sorry for the duplicate post, I had an error message both times I tried
to send it. Thanks again!
 
Between DateAdd("yyyy",-1,Date()) And Date()

This expression gives you:
Between 10/29/2003 and 10/29/2004
 
Back
Top