Conditional logic + repeaters

Can I use both “And” and “Or” in the same expression when filtering a repeater. What I’m trying to do is set up an expression that will filter for two columns (say “Red” and “Blue”) as well as a date range (29/04/18 to 21/04/18).

So something like
[[Item.Colour = “Red” && Item.Colour = “Blue” && Item.Date == "???}} How would I set the date range? Do I use < and > less than? Or “.indexOf(‘searchValue’)”
Tx in advance

Since Axure isn’t great with dates, I would convert the date to MMDD format (ie. 29/04/18 => 0429). When its an integer like this you can then use operands.