Solved Build A Query "Like Current Year"

[pooldead]

Right off the top, I'd like to mention that I am trying to build this query in Query Design and not VBA, so that it can be used in a report chart.

I have a field with the date stored as yyyy-mm (2020-05). I'm trying to build a SELECT query that will pull data where the field has the current year. What I currently have is:

SELECT Field1
FROM Table1
WHERE Field1 Like "*(Year(Now()))*";

I don't get any errors with this, but the search pulls up empty. Can someone please assist?

 

[theDBguy]

Hi. What is the data type of Field1?

 

[pooldead]

Short text - but I tried with it as a number and Date/Time (formatted) as well and no luck

 

[theDBguy]

Short text

Try using a literal value first to see if you get back anything.

WHERE Field1 Like "*2020*"

 

[pooldead]

Yup, the literal value pulls the records.

 

[theDBguy]

Yup, the literal value pulls the records.

So, that tells me there's something wrong with your expression to pull the current year. Try this one next:

WHERE Field1 Like "*" & Year(Date()) & "*"

 

[pooldead]

That did the trick! Thank you!

 

[theDBguy]

That did the trick! Thank you!

Hi. You're welcome. I should have spotted it earlier, but I totally missed it. Good luck with your project.