add a year to the current date

3 posts / 0 new
Last post
ortizmario6025@...
Offline
Joined: 09/03/2021 - 11:54
add a year to the current date

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's picture
Brian Element
Offline
Joined: 07/11/2012 - 19:57

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.

ortizmario6025@...
Offline
Joined: 09/03/2021 - 11:54

Cheers,Thank you