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