2 Replies Latest reply: Aug 10, 2012 12:38 AM by Kiran Shinde RSS

    Max(Date) from two fields

      Hi All,

              I have one requirement where,there are three fields into one table viz.Item No ,Lot No. & posting date

      Item No        Lot No       Posting date

      A                    A1           08/08/2012

      B                    B1           07/08/2012

      A                    A2           04/08/2012

      C                    A1           09/08/2012



      so Max(Date) for A will be 08/08/2012

      & Max(Date) for A1 will be 09/08/2012


      when I will select A & A1 It will show Max(Date) =09/08/2012


      How can I achieve this?