Date range

  • Thread starter Thread starter Ken
  • Start date Start date
K

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.
 
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?
 
Yes it is a DateTime field. I tried both my expression
and your and got the same error "undefined
function 'date' in expression"
 
Back
Top