Retrieve records for the day before

  • Thread starter Thread starter Iris Faber
  • Start date Start date
I

Iris Faber

I have been trying to use Day()-1 and Date()-1 and >=(Date()-1) in my criteria field, to get the query to automatically append records to a table for the day before today's date. Also if I type in >=Date()-1, it automatically changes it to show as >=Date()-"1". It is pulling up nothing. Please help.
 
oops. That first part shoulda said...

=date()-1 should work.


"Rick B" <Anonymous> wrote in message =date()+1 should work.

Maybe try...
 
I put that in and got nothing. Then my query changed it to say =date()+"1". That's a little strange...I don't understand why it's doing that.
 
Sounds as if your date field is a Text field, not a Date/Time field. And
that would also explain why the criterion expression isn't working, as it's
not comparing to a date value but to a text string.
 
Back
Top