2 Replies Latest reply: Dec 12, 2017 1:18 AM by Irmantas Tubutis RSS

    How find MAX date with were?

    Irmantas Tubutis

      Hi Folks,


      I have Table like this:

      ItemId     OperationDate     Qty     StatusReceipt     StatusIssue

      XX          03/03/2017          1          Purch    

      XX          05/03/2017          1                                   Sale

      XX          06/03/2017          1          Ordered


      How I can find ItemId firs date of Purch and Last date of Sale in Expression?