How to add current date field in a confluence template

Jörg Bofinger August 30, 2017

Hi all,

I'm currently working on a knowledge template in a confluence space. 

I'm looking for a solution to have a filed which is filled whith the current date when the template us used by a user.

How can a do this..

Cheers Jörg

3 answers

3 accepted

4 votes
Answer accepted
Thomas Schlegel
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 30, 2017

Hi Jörg,

I would create a user macro "creationdate" (since this is what you want, I think):

## Macro title: creationdate
## Macro has a body: N
##
## Developed by: Thomas Schlegel

## @noparams

$action.dateFormatter.formatDateTime($content.getCreationDate())

Then, add the new macro "creationdate" to your template.

The creation date of the page is the same as the usage date of the template.

Brendan Byers July 17, 2018

Hello,

This solution works however it renders the date as a simple string.
Is there any way to create a macro that creates a date as a Date Picker Object:

DatePickerObject.png

We would like to add dates automatically to Tasks within a Template and the string based date doesn't add as much value as the date picker which displays as a due date in the Tasks screen.

Thank you,
Brendan

Bill Bailey
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 8, 2018

Hey Brendan,

I was playing around with the data picker format for another macro. Here is some sample code to retrieve the last modified date and format in the data picker format.

#set($dateInfo=$action.dateFormatter.formatGivenString("yyyy-MM-dd", $content.getLastModificationDate()))
<div class="content-wrapper"><p>
<time datetime="$dateInfo"/>
</p> </div>

Hope this helps you (or anyone else who stumbles across this.

Edward Brett
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!
October 10, 2018

Hi, this works really well, however I was wondering if it's possible to make the date picker editable after it has been added to the Confluence page via the macro, so that the date can be changed. Additionally, is it possible to get last modification date + 1 day or + 2 days?


Thanks,


Ed

0 votes
Answer accepted
Jörg Bofinger August 31, 2017

Good Morning Thomas,

I tried out your macro and it works well so far but...only in a native page template like "plain page"

Whe I try to place it in a template like "knowledge article" it didn't work !?!

I've no clou what te reason can be...

Please help..

-------------------

Please forget what I've wrote - it all works well... Thank you for your support!

Cheers Jörg

Thomas Schlegel
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 31, 2017

You're welcome, great you've made it :-)

If you think, your question is answered, please mark it as answered. With such a marker, other user may find answered questions more easy.

Viele Grüße aus Hamburg

0 votes
Answer accepted
Jörg Bofinger August 30, 2017

Thank you Thomas for your answer.

Just for me as a Confluence rookie... how do I add the user macro to the template?

Thanks again..

Thomas Schlegel
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 30, 2017

You create a user macro in your admin section. 

The user macro is added the same way as a regular macro. You find it in your list of macros after you've created it.

I've written an article about creating user macros, maybe it helps you:

https://community.atlassian.com/t5/Confluence-articles/The-Admin-s-tale-User-Macro-filtering-a-Confluence-table/ba-p/459369

But if not, don't hesitate to ask again :-)

Terri Isidro December 18, 2023

Hello, I am an admin but I under General Preferences I don't see anything listed re: User Macros.

Lower down in preferences there is a section that says "Macro Usage" but when I click it nothing appears in the right panel (basically nothing happens).

Capture.JPG

If I was made an admin, shouldn't I be able to view and update macros as described here?

Specifically I'm trying to include a macro that can be inserted to show when a page was last updated in our knowledge base article template I created.

I found this code in another community post and was hoping to test it but can't access the area where to update macros at all:

## @noparams
#set ( $dateInfo=$content.lastModificationDate)
Last Modified: $dateInfo


Suggest an answer

Log in or Sign up to answer
TAGS
AUG Leaders

Atlassian Community Events