The 'IN' condition in query builder doesn't seem to work for me... help appreciated

Hi,

I’ll keep it quick.

I’m just playing around still but trying to return a query using the IN condition and it will only work when 1 value is in there…the moment i put more than 1 value it returns nothing.

With the below screenshot, i am using a condition on week numbers in a year. If i put in 36 as an example it will work fine, returning only corresponding data for week 36. Same if i put in 37. But if i have both 36 and 37 (or any other combination) it returns NO data.

As far as i can tell using w3Schools, the syntax is correct and SHOULD work.

Any ideas on what i’m doing wrong?

image.png1528×885 74.4 KB