fetching Month from a Date we give

[prash248]

Hi Team,

I have a use case where I need to find which month does a given date belong to.

Could you please help me

Thanks & Regards

Prashanth Akula

[DavidSmith · Accepted solution]

I think the INPERIOD() function will work for that.
Or you could do a check using START() and END()
David

[kavinkumar · Accepted solution]

HI @prash248,

Please use the time function 'PERIOD(Date formatted line item)'.

I hope this helps!!

Regards,

Kavin.

[usman.zia]

Hi @prash248 

To do this you need to use the formula PERIOD(x), where x is a date formatted line item.

The resulting line item needs to have the Month format.

https://help.anaplan.com/anapedia/Content/Calculation_Functions/All/PERIOD.html

I hope this helps.

Usman