6 Replies Latest reply: Feb 22, 2018 12:53 AM by Darmawan Suria RSS

    Get Max Value and Date

    Darmawan Suria

      Hi,

       

      Anybody can help me, how to get what Date and Max Value in Month?

       

      I just want to get Max Tot_Trans in a month and what the date of that Max Value in a month

       

      Date               Year_Month     Tot_Trans

      31/1/2017       2017/01            19,084,195.00

      28/2/2017       2017/02             22,483,191.00

       

      Date is t

       

      Thanks A lot

       

      Darmawan