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

Tags

Modeling

Accepted answers

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

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

I hope this helps!!

Regards,

Kavin.

All comments

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

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

I hope this helps!!

Regards,

Kavin.

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

Quick Links

Can you help?

Unanswered questions

ADO Certification - Cannot Create Migration Link
Hi - I cannot seem to create a migration for Assignment 3 and it will not allow me to update the hierarchy and proceed further. It seems to think that a link has already been created, but I don't see anything. Any ideas?
How can i export accuracy metrics from Anaplan Forecaster to Model.
There was an error rendering this rich post.
A reminder of Bulk Copy - Current year to Prior year version for YoY analysis
A quick reminder of the Bulk Copy functionality. Bulk Copy allows you copy large volumes of data from one slice of a model to another in a single, optimised operation, instead of using formulas or imports. Use case: copy a version (RF1) into a prior year version (PY RF1) using a versions list to allow for year-on-year…