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,

      Gareth