How can I get current date from confluence page automatically?

Solar CHEN
I'm New Here
I'm New Here
Those new to the Atlassian Community have posted less than three times. Give them a warm welcome!
August 25, 2024

I create tables in confluences, and I want the date can be updated automatically. How can I get current date from confluence page automatically? and can I use add or subtraction function for date calculations?

2 answers

4 votes
Stiltsoft support
Rising Star
Rising Star
Rising Stars are recognized for providing high-quality answers to other users. Rising Stars receive a certificate of achievement and are on the path to becoming Community Leaders.
August 26, 2024

Hi @Solar CHEN ,

If it happens so that you use the Table Filter, Charts & Spreadsheets for Confluence app (that is our add-on) in your company, you may use 

  • The Table Transformer macro if you prefer to work with native Confluence tables. It supports the "today" function as well as DATEDIFF expression and so on (the macro is based on the AlaSQL library)
  • The Table Spreadsheet macro if you prefer to work using Excel-like style with all the familiar cell formulas

Simple native Confluence tables don't have the functions that you've described in your question.

1 vote
Kristian Klima
Community Leader
Community Leader
Community Leaders are connectors, ambassadors, and mentors. On the online community, they serve as thought leaders, product experts, and moderators.
August 25, 2024

You can use a Confluence Databases macro configure the following way.

Page link - date created - date updated

This will create a DB (table) on a page with all the details - and it gets the dates automatically.

Or you can create a centralized database of all pages with all the details

Suggest an answer

Log in or Sign up to answer
TAGS
AUG Leaders

Atlassian Community Events