5 Replies Latest reply on Jan 14, 2016 8:28 PM by SriniVEERAVALLI

    How to calculate month end dates from all months?

    ARIVEMULA KAVYA KUMARI, LERA TECHNOLOGY PVT LTD

      Hi,

       

      I am getting last day of current month. That formulae is

       

      TIMESTAMPADD( SQL_TSI_DAY , -(1), TIMESTAMPADD( SQL_TSI_MONTH , 1, TIMESTAMPADD( SQL_TSI_DAY , DAYOFMONTH( CURRENT_DATE) * -(1) + 1, CURRENT_DATE)))


      But, I want month end dates only from all months.i need  formula for this.

      Please help me.

      Thanks & Regards,

      A.kavya.