fetching Month from a Date we give

New Contributor

fetching Month from a Date we give

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

 

Message 1 of 4
3 REPLIES 3
Community Boss

Re: fetching Month from a Date we give

I think the INPERIOD() function will work for that.
Or you could do a check using START() and END()
David
Message 2 of 4
Highlighted
Certified Master Anaplanner

Re: fetching Month from a Date we give

HI @prash248,

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

I hope this helps!!

Regards,

Kavin.

Message 3 of 4
Community Boss

Re: fetching Month from a Date we give

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

Message 4 of 4