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

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

kavinkumar

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