Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations TouchToneTommy on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Get Yesterday's Date

Status
Not open for further replies.

caykamanj1966

Technical User
Jun 23, 2013
45
US
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
 
I found what I needed, which is this:

Date()-1

Thank you all for all of your help, all the time!!!
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top