Criteria Date() - 1 or Date()

[ypma]

Advise required. I have query with a date time field which is populated with a now time when it was created . I am trying to filter records that were created yesterday "date()- and records for to day "Date(). I have tried using the "or" , but failed to selected records containing todays date and time.
Any pointers would be appreciated
Regards Ypma

 

[plog]

I would create a calculated field based on DateDiff (https://www.techonthenet.com/access/functions/date/datediff.php):

DaysOld: DateDiff("d", [YourDateFieldHere], Date())

Then in the criteria you put 0 or 1

 

[JHB]

.. but failed to selected records containing todays date and time.
Any pointers would be appreciated
Regards Ypma

It fails because of the time value in the field. Use the function DateValue to get only the date.

... DateValue([YourDateFieldHere])

 

[ypma]

Plug and JHB, thank you very much for responding to my cry for help. I will test both suggestions to see which one suits my end game which is to sort by time .