The Atlassian Community Forums are currently in read-only mode. We will be relaunching on a new platform on September 22 (read more here). We apologize for the extended downtime. For concerns or questions, please email communitymanagers@atlassian.com. See you on the other side, on the new Atlassian Community Forums! :)

×

Forums

Articles
Create
cancel
Showing results for 
Search instead for 
Did you mean: 

Color format a date (without task) based on custom due date

Andreas Sundvall
Contributor
December 29, 2022

Hey,

I'm looking for a way, in a Confluence page, to color format a date once a custom due date has passed.

Similar to the formatting done using //task but preferrably using //date function.

 

1 answer

Comments for this post are closed

Community moderators have prevented the ability to post new answers.

3 votes
Katerina Rudkovskaya _Stiltsoft_
Atlassian Partner
December 29, 2022

Hi @Andreas Sundvall,

If your company uses our Table Filter and Charts for Confluence app and you store your dates in a table, you may use our Table Transformer macro for conditional formatting. You may check this page for several examples.

The other option is to use the Table Spreadsheet macro where you can also compare dates and format cells.

We’ll be also happy to organize a live demo for you and your colleagues – please book a suitable time slot here.

Andreas Sundvall
Contributor
December 31, 2022

Thank you @Katerina Rudkovskaya _Stiltsoft_  for those suggestions. 

The spreadsheet formatting would work but doesn’t offer the Confluence look and feel. 

I was hoping there was a similar solution as there is for //task where a passed date is automatically formatted. But without having to use //task and just //date, preferably where  one can customise the “older than” value. 

Like # people like this
DEPLOYMENT TYPE
CLOUD
PRODUCT PLAN
PREMIUM
TAGS
AUG Leaders

Atlassian Community Events