3 Replies Latest reply: Dec 19, 2017 12:44 PM by Massimo Grossi RSS

    most recent quarter end date

    Kristina Stephenson

      Hi All,

       

      I have an EndDt field in format YYYY-MM-DD. I would like to return the value of the most recent quarter end date.

       

      For example, if my EndDt is 2017-07-31, I would like to return 2017-06-31 (Q2 EndDt). If my EndDt is 2015-09-30, this falls on a quarter end date so this would return the same value - 2015-09-30.

       

       

      Thanks!

      Tina