You can now reference the current year and the current month as plain numbers in your formulas, alongside a new CurrentYear parameter for year-level conditional logic.Your formulas can now reference the current calendar year and month as numbers, opening up a new class of time-based calculations that were not possible before.

✨ What's new

Three new parameters are now available in Model Builder: CurrentYear, MonthNumber, and YearNumber.

CurrentYear brings year-level conditional logic to your formulas, using the same syntax you already know from CurrentMonth. You can now apply different assumptions based on the calendar year, making it straightforward to model year-specific one-offs, phased transitions, or multi-year plans directly in your formula logic.

MonthNumber and YearNumber take a different approach: rather than being used in conditions, they return the current period as a plain number you can use in arithmetic. This unlocks a range of calculations that depend on where you are in the year or how far along a multi-year plan you are.

⚙️ How it works

• CurrentYear works exactly like CurrentMonth in conditional statements: IF (CurrentYear IS 2024) THEN (Revenue.t-1 * 1.08) ELSE (Revenue.t-1 * 1.12). 
• MonthNumber returns a value from 1 to 12 (January = 1, December = 12), and YearNumber returns the four-digit calendar year, both ready to use in arithmetic formulas: YTD Target = Annual Target / 12 * MonthNumber or Base Salary = Starting Salary * (1.03 ^ (YearNumber - 2024)). All three parameters reflect the natural calendar, independent of fiscal year configuration, and are available in both Actuals and Version formulas.