Setting Planning year based on date

Hi,

I have system module for time settings, and based on Today's date line item I'm trying to set Planning year which is current year + 1, when I'm selecting date between jan to dec 2022 it is showing me plan year as FY23 which is correct, but when I'm selecting date from JAN 2023 to Dec 2023 "Planning year" line item is becoming blank.

Today's date is date formatted and Planning year is year formatted line item.

Accepted answers

StevenBeerthuizen

Your planning year is one year ahead, right....your current year is 2023 and you have no future years. So date 11/1/2023 -> Period(date) +1 = FY24....which is not in your model range. You should add future years if you want your formula to work:

PERIOD - Anaplan Technical Documentation

Constraints

Source must be date formatted.
Result must be time period formatted.
Result must fall within the time bounds of the model.

All comments

StevenBeerthuizen

Does your time range contain the planning year?

Schermafbeelding_2022-12-06_091651_153569.jpg

swapnil_J

Hi @StevenBeerthuizen, The system module dont have time as a dimension, Also I tried same by selecting Previous dates between Jan 2021 to dec 2022 and it is working fine, but it is not working when I'm selecting dates from Jan 2023 to Dec 2023.

I have tried this by updating the model calendar as well.

StevenBeerthuizen

PERIOD - Anaplan Technical Documentation

Constraints

Source must be date formatted.
Result must be time period formatted.
Result must fall within the time bounds of the model.

swapnil_J

Thank @StevenBeerthuizen, got the result after updating time range.

StevenBeerthuizen

No problem @swapnil_J

Since your issue is solved, maybe you can mark this topic as solved.

Kr,

Steven

Quick Links

Can you help?

Unanswered questions

Excel date format for February 2030, 2031 and so forth don't align with Anaplan format
Hello, I’m running into a recurring issue when importing CSV files into Anaplan, specifically with dates in February for the years 2028, 2029, and beyond. Here’s what’s happening: In Excel, the date format is set to Custom (e.g., 2/26/2025). When imported into Anaplan, the date is interpreted as 26-Feb, where: Month = Feb…
RANKCUMULATE not working when adding additional dimensions to module
I have an issue where I am getting the expected result from RANKCUMULATE when using one dimension, but when I add an additional scenario dimension to the module, it doesn't calculate the way I'd expect. Here are some screenshots to explain the case: Module 1 - calculates cumulative total for list items in list "Age"…
Introducing Anaplan API Python SDK
Hey everyone, I wanted to share the Anaplan Python SDK with you. It's a Python Library that wraps all Anaplan APIs and makes it easier to interact with Anaplan programmatically. It is mostly designed with Data Integration Scenarios in mind, but it does support all APIs including ALM, SCIM, Audit, and Cloud Works. Please…