[DONE] Months() and Years() function in formula

[Jonathan1]

Will it be possible to add Months() and Years() function in formulas ?

The idea is to be able to add or remove X months or X years from a date (as we currently can do with Days() function).

[Chr1sG]

Related

Add a number of months to a date

I need to add a number of months (in Paid Terms field) to a date (in License From field). This is what I was able to do figure out so far: Date(If(Month([License From]) + [Paid Terms] > 12,Year([License From]) + 1,Year([License From])),If(Month([License From]) + [Paid Terms] > 12,Month([License From]) + [Paid Terms] - 12,Month([License From])),Day([License From])) Sadly, it doesn’t work. The calculated field shows exactly the same date as in License From. Nothing is being added. :-/ I’ve alr…

[mdubakov]

We are going to improve formulas next year only, no plans to do it this year so far

[Jonathan1]

Thanks for the feedback.

[mdubakov]

Months(x) formula released today

January 9, 2025 / Set any relative value in Date Filter, Batch change fields for selected entities, Improved readability in rich text fields, some new formulas

First release in 2025 brings you some good stuff! Set any relative value in Date Filter We’ve significantly expanded our Date Filter capabilities to support more flexible time-based filtering. When filtering by Date Field, you can now choose from convenient preset options like “today,” “yesterday,” and “one week from now,” or use the “custom date” option to select either specific dates or relative timeframes. The “is within” operator has also received a major upgrade. You now h…

[Chr1sG]

Marked as solved, since adding n years is the same as adding 12 x n months