13 Replies Latest reply: Mar 23, 2016 9:03 PM by jagan mohan rao appala RSS

    Last Date Of the Month

    Pradeep Kumar Pandey

      Hi All

       

       

      How to get the last date of the month in the expression Max({<Year={$(=Max(Year))},Month={$(=Month(Max(TranDate)))}>} TranDate)

      where TranDate is in DD/MM/YYYY format and I need the last date of the month also in the same format.