Selecting value with only today or yesterday's date In Query (day/month only)

[taimysho0]

Hello, i have a query that searched for certain string criteria in a column. How do i have it only find values that have a Date in front of the text? However, the date is in the form of 5/24 for example. There is no year.

There are only two possibilities what what the date would look like either between Date() and Date()-1 or Date() and Date()-2. For example, it would look like this is in the field:


either "5/24 - 5/22 is missing data" <---between date() and date()-2

OR

"5/24 - 5/22 is missing data" <---between Date() and date()-1

The way i have the query right now is just find anything that says "missing data", how do i add the date criteria also?



maybe something like: Like Date() & " - " Date()-1 & "is missing data"??

[Bob Fitz]

Try this:
Like CStr(Format(Date(),"m/dd")) & " - " & CStr(Format(Date()-1,"m/dd")) & " is missing data"

[taimysho0]

hrmm i have lines with "5/24 - 5/22 is missing data" and is still not being pulled up in the query. Does it matter what format that column is in? currently its jut text

[Bob Fitz]

To return that row you would need:
Like CStr(Format(Date(),"m/dd")) & " - " & CStr(Format(Date()-2,"m/dd")) & " is missing data"

[taimysho0]

nvm, looks like i got it. thanks so much!

[Bob Fitz]

Glad to help.