Date Input is outside the model time range

New Contributor

Date Input is outside the model time range

Hi, 

 

I have a date formulas calculation to test whether the line item is falling within certain year, however cannot figure out what to do for the lines that fall outside of the model time period set up.

 

For example, I have a contract that starts from 2020 to 2025 and the model is set up as 2 past year and 2 future year (so the model only captures up to 2022 currently). When I do the formula, because 2025 is outside my model time set up, it will always give false even though technically time now is less than 2025. Is there a way to get this right?

 

Can anyone help?

Thanks!

1 REPLY 1
Master Anaplanner/Community Boss

Re: Date Input is outside the model time range

@heron 

If you create a time range that includes 2025 then that should appear in your model. Link here for more info on time ranges: https://help.anaplan.com/2d10945f-3e50-4310-beee-5a332269ce0e-Time-Ranges

 

jasonblinn_0-1608583106616.png

 

 

By doing this, you are increasing the superset, and 2025 (and 2023 and 2024) will appear in your formula, and it will not add size (unless you dimensionalize something by the new time range).

Information of Time period Selection, and the superset here: https://help.anaplan.com/3d477887-b264-4105-b3b7-5fcad2af1255-Time-Period-Selection

 

Jason