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.