Date range

[Ken]

Despite my attempts to understand the help screens in
Access, I'm having trouble getting my query to list only
records from the last year (365 days). The help screens
say that this should work
Between Date() And Date()-365
but I keep getting errors. Help me to understand what
I'm doing wrong.

 

[Van T. Dinh]

To be more precise (remember, there are leap years), you should be using:

BETWEEN DateAdd("yyyy", -1, Date()) AND Date()

Is the Field you used in the criteria a DateTime Field?

What error message did you get?

 

[Ken]

Yes it is a DateTime field. I tried both my expression
and your and got the same error "undefined
function 'date' in expression"

 

[Van T. Dinh]

Easily fix: you have errors in the References Collection of your database.
See Douglas J. Steele's article:

http://members.rogers.com/douglas.j.steele/AccessReferenceErrors.html

That's why you should *always* include the error message in your post if you
get an error.