5 Replies Latest reply: Sep 24, 2018 6:02 AM by Justin Pham RSS

    Max Month end Date

    gowtham Ganapathi

      Hi all,

       

      Can you please help me to get the Max Month end date for the below set of data.

       

        

      REPORT_DATEMonth
      01/07/2018Jul

      02/07/2018

      -

      Jul

      -

      24/07/2018Jul
      25/07/2018Jul
      26/07/2018Jul

       

       

      I tried with below expression its giving me 31st Jul.

       

      I need 26th Jul

       

      Date(MonthEnd(Max(REPORT_DATE)),'YYYY-MM-DD')

       

      Thanks,

      Gowtham