nav[aria-label="Primary Navigation"] { padding: 0; & ul { list-style: none; width: 100%; display: flex; flex-direction: row; justify-content: start; align-items: start; gap: 30px; padding: 0; & li { margin: 0; } & ul li { list-style: none; } } }

How to evaluate values on Confluence Page?

Troy S

I what to report the number of days until a due date. The pseudo code might look like:

June 15, 2012 - NOW() = 63 days

Can a Confluence Webpage generate the value dynamically when before it is presented to the user to let them know the number of days before the due date?

I hope that make sense.

Thanks,

Troy

Accepted answers

Remo Siegwart

You could write a user macro for that. Here is my example that counts down the number of days until a specific date:

## Macro title: Date Countdown
## Macro has a body: No
## Body processing: No macro body
##
## Developed by: Remo Siegwart
## Date created: 14/04/2012

## This user macro counts down the number of days until a specific date
## @param endDate:title=End Date|type=date|required=true|desc=The end date. Format: mm/dd/YYYY

## declare variables and initialize as java date objects with current date
#set ( $endDate = $content.currentDate )
#set ( $currentDate = $content.currentDate )

## parse endDate param to milliseconds and set as time of endDate variable
$endDate.setTime($content.currentDate.parse($paramendDate))

## now we have 2 valid java date objects to work with

#if($currentDate.before($endDate))

## currentDate is before endDate =&gt; calculate deltas
#set( $delta =  ($endDate.getTime() - $currentDate.getTime()) / 1000)

## calculate remaining seconds
#set( $deltaSeconds = $delta % 60 )
#set( $delta =  $delta / 60 )

## calculate remaining minutes
#set( $deltaMinutes = $delta % 60 )
#set( $delta =  $delta / 60 )

## calculate remaining hours
#set( $deltaHours = $delta % 24 )
#set( $delta =  $delta / 24 )

## calculate remaining days
#set( $deltaDays = $delta % 365 )

&lt;div class="aui-message info shadowed"&gt;
  &lt;p&gt;Countdown until &lt;strong&gt;$action.dateFormatter.format($endDate): $deltaDays days $deltaHours hours $deltaMinutes minutes $deltaSeconds seconds&lt;/strong&gt;&lt;/p&gt;
&lt;/div&gt;

#else

## currentDate is after endDate
&lt;div class="aui-message success shadowed"&gt;
  &lt;p&gt;Countdown to &lt;strong&gt;$action.dateFormatter.format($endDate)&lt;/strong&gt; expired &lt;strong&gt;$generalUtil.getRelativeTime($endDate)&lt;/strong&gt;!&lt;/p&gt;
&lt;/div&gt;

#end

Learn more about user macros here: Guide To User Macro Templates

Hope this helps

All comments

Remo Siegwart

You could write a user macro for that. Here is my example that counts down the number of days until a specific date:

## Macro title: Date Countdown
## Macro has a body: No
## Body processing: No macro body
##
## Developed by: Remo Siegwart
## Date created: 14/04/2012

## This user macro counts down the number of days until a specific date
## @param endDate:title=End Date|type=date|required=true|desc=The end date. Format: mm/dd/YYYY

## declare variables and initialize as java date objects with current date
#set ( $endDate = $content.currentDate )
#set ( $currentDate = $content.currentDate )

## parse endDate param to milliseconds and set as time of endDate variable
$endDate.setTime($content.currentDate.parse($paramendDate))

## now we have 2 valid java date objects to work with

#if($currentDate.before($endDate))

## currentDate is before endDate =&gt; calculate deltas
#set( $delta =  ($endDate.getTime() - $currentDate.getTime()) / 1000)

## calculate remaining seconds
#set( $deltaSeconds = $delta % 60 )
#set( $delta =  $delta / 60 )

## calculate remaining minutes
#set( $deltaMinutes = $delta % 60 )
#set( $delta =  $delta / 60 )

## calculate remaining hours
#set( $deltaHours = $delta % 24 )
#set( $delta =  $delta / 24 )

## calculate remaining days
#set( $deltaDays = $delta % 365 )

&lt;div class="aui-message info shadowed"&gt;
  &lt;p&gt;Countdown until &lt;strong&gt;$action.dateFormatter.format($endDate): $deltaDays days $deltaHours hours $deltaMinutes minutes $deltaSeconds seconds&lt;/strong&gt;&lt;/p&gt;
&lt;/div&gt;

#else

## currentDate is after endDate
&lt;div class="aui-message success shadowed"&gt;
  &lt;p&gt;Countdown to &lt;strong&gt;$action.dateFormatter.format($endDate)&lt;/strong&gt; expired &lt;strong&gt;$generalUtil.getRelativeTime($endDate)&lt;/strong&gt;!&lt;/p&gt;
&lt;/div&gt;

#end

Learn more about user macros here: Guide To User Macro Templates

Hope this helps

Troy S

Thanks for your help Remo.

Is this feature available in Confluence 3.5?

Do I need special admin privileges to create and install a user macro?

I can't find where I would install the user macro.

Thanks,

Remo Siegwart

Yes, user macros are available in Confluence 3.5, but you need to have System Administrator permissions in order to create user macros.

Source: Writing User Macros

Reatha Ek

Hi!

I am looking for a way to manage document retention periods. Imho this could be used just to do that, provided that every document has a clearly set end-date?

Could that be extended in a way that documents that are beyond the end date will be archived and/or purged?

Kind regards

Bernd

Tim1979

hi,
thank you for this macro!

but the macro does not calculate the correct number of days.

30.12.2012 (US 12/30/2012)

and

30.12.2013 (US 12/30/2013)

it comes out the same result?

why?

thank you for your help

Roger Henty

Hello,

I'm trying to setup a user macro that inserts a current timestamp on new entries as they're added to a page.

I'm able to show the current time/date using the below, but I'm having trouble figuring out how to get the value to remain static, rather than updating to show the current time:

## @noparams

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

I wondered whether anyone would have suggestions on what I'd need to add to get this to act as an actual timestamp rather than a clock?

Thanks!

CelesteCS

Hello,

For simple calculations have a look at CelesteCS Math for Confluence plugin: https://marketplace.atlassian.com/plugins/com.celestecs.confluence.celestecs-math. Macros as well as table cell values may be used as formula operands.

----- UPDATE -----

We have added Date type support to Math macro so from now you may use our macro to accomplish what you want. Just specify the EXCEL-style formula, like "DAYS(NOW(), DATE(2016, 04,17))".

Thanks!

Welcome!

It looks like you're new here. Sign in or register to get started.

Quick Links

Find more posts tagged with

confluence

user-macro

dynamic