Filter by Date not working

Question

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

Ian C · Accepted Answer

Hi, 
 Thanks for using Sage City. 
 I think this is to do with the order of where the brackets have been placed on the filter. 
 Try adding the date first and net last. 
 I tried the following example which worked. 
 Where 'Date' > '01/04/2019' And ('Transaction type' = 'BP' Or 'Transaction type' = 'PP' Or 'Transaction type' = 'PA') And ('Transaction deleted flag' = 'No' And 'Net amount' > '100.00') 
 If this has answered your question please click More > Verify Answer. 
 Regards, 
 Ian 
 Sage UKI

Sage 50 Accounts

Filter by Date not working

Top Replies

COMMUNITY

COMPANY

PARTNERS

SUPPORT & TRAINING