Filter by Date not working

SOLVED

Hello 

I have set up a filter to pull off payments over a certain amount and one of the criteria is 

And Date Is Greater Than xx/xx/xx.

All the other conditions in the filter work but I am getting all dates.

Any ideas why this is not working as it should, please?

Here is the expression in full

Where 'Net amount' >= '500.00' And ('Date' > '01/04/2019' And 'Transaction type' = 'BP' Or 'Transaction type' = 'PP' Or 'Transaction type' = 'PA' And 'Transaction deleted flag' = 'No')

Thank you

Parents Reply Children
No Data