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).

Months(x) formula released today [image] January 9, 2025 / partying_face Set any relative value in Date Filter, Batch change fields for selected entities, Improved readability in rich text fields, some new formulas Changelog First release in 2025 brings you so…

Related [image] [DONE] 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,…

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

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

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

Ideas & Features

Chr1sG October 20, 2024, 7:24am 2

Topic		Replies	Views
[DONE] Add a number of months to a date	8	535	January 9, 2025
[DONE] More manipulation data functions Ideas & Features	8	400	January 9, 2025
Difference between two dates in years Ideas & Features formulas	2	474	May 24, 2021
[DONE] Missing „this month“ in „within“ filters Ideas & Features	6	87	January 9, 2025
Calculate next renewal date Get Help	8	517	July 21, 2023

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

Related topics