add a year to the current date

ortizmario6025…

Forums

Hello, I have to get a list of the documents to expire, where I have today's date (@date), it happens that for future expirations I have to add a year to this date, I have tried with @year(@ date() +1 but it only gives me 2023 and I want the entire date, that is, if today we are at 2022/09/23, the new date must be 2023/09/23
How would I achieve this?

Brian Element Tue, 09/27/2022 - 06:46

This is not the easiest thing to do in the equation editor as you are working with numbers, characters and dates.  If you have the latest version of IDEA you can download the Custom Functions package from the IDEA lab.

There is a function in there that does exactly what you are looking for, namely allowing you to add or subtract years, months and/or days.