Formula for current month

ansn
Occasional Contributor

Formula for current month

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.

3 ACCEPTED SOLUTIONS

Accepted Solutions
Misbah
Moderator

@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

View solution in original post

Javvaji45
Contributor

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

solution-1.jpgSolution.jpg

View solution in original post

ansn
Occasional Contributor

Thank you all for the help.

The END() formula is serving the purpose.

View solution in original post

3 REPLIES 3
Misbah
Moderator

@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
Contributor

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

solution-1.jpgSolution.jpg

ansn
Occasional Contributor

Thank you all for the help.

The END() formula is serving the purpose.