Date() or (Date())-1

[OZmc]

this is a weird one.
I have a form that inputs a short date into the target table on load.
now I want to make a query that returns all records made today or yesterday.
I am using a query that looks in the date_record field: the total field is "where" and the criteria is Date() Or (Date())-1

Whats odd is (Date())-1 works but the simple Date() doesn’t return any values.

 

[MarkK]

A "Short Date" is setting you can use with the Format function to display a date. A date is not stored as a "Short Date."

And you're saying you OR dates together? Like this?

WHERE Date() Or Date() - 1

... or do you have a field in there?

WHERE MyDateField = Date() Or Date() - 1

Do you see that probably neither of those are what you mean to do. Consider ...

WHERE MyDateField >= Date() - 1 AND MyDateField <= Date()

... or at a minimum ...

WHERE MyDateField = Date() - 1 OR MyDateField = Date()

Hope this helps,