Filter with multiple AND conditions not working

[Crispy131]

Hi, I have data that looks like the following:

Date                Number  Department

2023-10-31          2               VB01

2023-10-30          2               VB01

2022-01-01          2               VB08

2022-02-02          3               VB03

2023-10-30          4               VB04

Basically I want to filter the data so that any record that has the Number 2 AND has Department VB01 AND has either 2023-10-31 OR 2023-10-30 as the date should be filtered out. So in the example above the first two rows should be filtered out.

I am trying to use the following filter but no matter what I try it doesn't work.

[Number] != 2
AND
[Department] != "VB01"
AND
([Date] != "2023-10-30"
OR
[Date] != "2023-10-31")

Any help is really appreciated!

[sergejs_kutkovics · Accepted solution]

@Crispy131 , recheck data type of yours Number column.  If it is text, you need to quote the value in the filter expression.

!([Number] = '2' and [Department] = 'VB01' and [Date] in ('2023-10-30', '2023-10-31'))

 

Hope it helps.