Formula for current month


I need a formula that can give me the actual Last day of the current month. As the current month is October'21, I want to get the result as 10/31/2021.

Can someone help me with the formula or guide me with a way around.


Best Answers

  • Misbah
    Answer ✓


    If your module has Time as a dimension then use



    if it doesn't then you can write

    END(Line item)

    Line item has to be Time Period formatted



  • Javvaji45
    Answer ✓

    The End() function can be used to obtain the end date of the current period.


  • ansn
    Answer ✓

    Thank you all for the help.

    The END() formula is serving the purpose.