Formula for current month

ansn
ansn
in Modeling

Hi,

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.

Tagged:

Best Answers

  • Misbah
    Misbah
    Answer ✓

    @ansn 

    If your module has Time as a dimension then use

    END()

     

    if it doesn't then you can write

    END(Line item)

    Line item has to be Time Period formatted

     

    Misbah

  • Javvaji45
    Javvaji45
    Answer ✓

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

    solution-1.jpgSolution.jpg

  • ansn
    ansn
    Answer ✓

    Thank you all for the help.

    The END() formula is serving the purpose.

Categories