8 Replies Latest reply: Sep 18, 2017 4:05 AM by Gareth Lloyd RSS

    Expression Help

    Gareth Lloyd

      Hi guys,


      I have two fields, Supplier Number and Min Invoice Date.


      How would I write an expression that counts all Supplier Numbers whereby the Min Invoice Date value falls within the previous month;


      For example a Supplier Number has a Min Invoice Date of 12/08/2017 so I want this to be counted as it falls between 01/08/2017 and 31/08/2017


      Many thanks,