caykamanj1966
Technical User
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
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