2 Replies Latest reply: Jan 21, 2013 6:49 AM by tiv0li321 RSS

    Concat max dates of currently selected field value

      Hello,

      My table is:

      WHDate1
      WH101.01.2013
      WH102.01.2013
      WH203.01.2013
      WH304.01.2013
      WH305.01.2013
      WH306.01.2013
      WH407.01.2013

       

      My goal is to show max date of currently selected Warehouses (WH)!

       

       

      For selected WH3 and WH2 I want to see: Last record for WH3 - 06.01.2013, WH2 - 03.01.2013

       

      For concat dates I've played with this(does not work):

       

      Concat(Aggr(Date(RangeMax({1<WH={"$(=WH)"}>} Date1)),WH),',')