2 Replies Latest reply on Feb 13, 2020 3:04 PM by Joshua Milligan

    Converting quarter date to month end date

    TRS S

      Hi- I have a dimension date that is in quarterly. and I need to make that to monthly end date.

       

      example; 10/31/2019 (is quarter 4)

       

      convert to monthly end date that is 12/31/2019.

       

      Is there a way to write a calculation that would convert the quarters to monthly end date?

       

      Thanks in advance.