Get Yesterday's Date

[caykamanj1966]

In the criteria field of my query, I am trying to pull all records that are from yesterday.

This is what I have but it is also getting, the previous years record, but the current day and month, with previous year.

So for instance it is getting all records from yesterday (i.e 4/18/2023), but also it is getting (4/19/2022). Here is what I am using in the criteria field of my query:

>i=int(now())-1 and <int(now())

Why is it getting the additional records?

Please help and thanks in advance

 

[caykamanj1966]

I found what I needed, which is this:

Date()-1

Thank you all for all of your help, all the time!!!