Query by date not working.

[sawdustmaker]

I am doing a simple query with criteria from a date field.
I use the format #10/13/2022# and I get nothing yet there are lots of records with that date.

Access 2013, 2019, 2020.

This is very weird.
Also if I use a >#10/12/2022# I get 10/12/22 dates but not all.
I assume I should not get 10/12/22 because it it equal to but not greater.

Driving me crazy.

using QBE
sql:
SELECT OpenJobsSpecs.[JobName-Number]


FROM OpenJobsSpecs
WHERE (((OpenJobsSpecs.DateOfMFG)=#10/12/2022#));

[Welshgasman]

Likely have a time element in that field?
In which case use DateValue()

I assume I should not get 10/12/22 because it it equal to but not greater.

Well yes?. use >=

[Micron]

Well yes?. use >=

Methinks it is likely because as you've said, there is time in the field values and some records either didn't get a time portion so they are, or they defaulted to 00:00:00 (hh:mm:sss). Thus the missing records are not greater than 10/12/2022 00:00:00 but they might be = to.
If DateValue solves the problem, it would be a much easier solution than what I used to do for this issue - adding 1439 minutes to the criteria!

[sawdustmaker]

Thanks, look like format is date time.

[Welshgasman]

Thanks, look like format is date time.

That is the same be it a date value, a time value or both.

Look at what that field contains.
Is the field populated with Date() or Now(), or what?

[Micron]

@sawdustmaker - You're probably referring to the data type (date/time). The field can be formatted in several ways. Perhaps you have it formatted as Short, Medium or Long Date.
Change it to General Date and see what you get.