Date Input is outside the model time range




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?


Best Answer