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"??