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; } } }

Calculating dates from a start date

sian hamer_zgjn9i

I currently create a confluence page per software release by copying the previous release page. The start / end dates for each task is essentially a start date + n days.

Is there any way to calculate this automatically? ie setting the start date and the page calculates all the following dates?

I am not particularly technical, so if anyone knows a simple solution it would be great.

Thanks

Accepted answers

All comments

Courtney Langdon_729kju

I would like this ability, too. I'm trying to convince a group of users to utilize Confluence instead of Excel for their project information, but not being able to calculate future dates based on a start date in Confluence (especially when Excel can) is a deal breaker for them.

Any work-arounds? Potential future release?

Thanks!

Andrey Khaneev _StiltSoft_

This can be done with Table Transformer macro (Table Filter and Charts app). Here is example:

The source table
Adding the Table Transformer macro
Add this query

SELECT *, 
(T1.'Start Date' + "5d")::Date->toLocaleDateString() AS 'End Date' 
FROM T1

4. Ensure that there are 24 hours in day are set 5. Get the result The calculated date can be formatted in different ways if needed.

Andrey Khaneev _StiltSoft_

Something wrong with two first screenshots. Here they are

erzn

Hi @Andrey Khaneev _StiltSoft_ ,

is it possible to take time format as like: MMMM d, yyyy as Start Date?

I used the correct pattern in "Settings" as i got the pattern.

My Data:

Anmerkung 2020-04-22 145101.png

Andrey Khaneev _StiltSoft_

Hi @erzn,

Please, set the date format to M dd, yy in the macro settings (for dates like Apr 16, 2020).

Welcome!

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

Quick Links

Find more posts tagged with

confluence

template

filter

table

date

table-filter

table-filter-and-charts

calculated-field

table-transformer