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.
If your module has Time as a dimension then use
if it doesn't then you can write
Line item has to be Time Period formatted
The End() function can be used to obtain the end date of the current period.
Thank you all for the help.
The END() formula is serving the purpose.