How do I create a macro that adds 3 years to the last update date?

[Jenny O_Connell]

I am inserting a Page Properties macro with a table of document info including the date of the last update but we need to enter the date of next review manually.

Is there a way I can add three years to the "last update" to set a review date automatically?

PS I am really new at using macros in Confluence, just hoping that it is possible to do.

[Stiltsoft support]

Hi @Jenny O_Connell ,

You'll need a 3rd party app to calculate dates in Confluence.

For example, we can suggest trying our Table Filter, Charts & Spreadsheets app and its Table Transformer macro. You'll be able to add time periods to your dates and set statuses if the review date is coming close.