Create
cancel
Showing results for 
Search instead for 
Did you mean: 
Sign up Log in
It's not the same without you

Join the community to find out what other Atlassian users are discussing, debating and creating.

Atlassian Community Hero Image Collage

JIRA issue macro and recent dates

I'm having an issue with the way the JIRA issues macro renders the "Resolved" date. I noticed that for some dates (in the more recent past) it will show day of the week + time whereas for dates prior to that, it will show in MM/DD/YY + time format. Is there a way to force it to always show MM/DD/YY? I'm trying to build tables/charts using this field and the inconsistency is a problem.

 

Example:

Screen Shot 2021-12-20 at 2.29.18 PM.png

 

I'm not sure why this is happening because in JIRA itself, when I look at this field, the format is always MM/DD/YY:

Screen Shot 2021-12-20 at 2.29.35 PM.png

2 answers

Hi @Anita Suri ,

We can suggest using our app that is Table Filter and Charts for Confluence to aggregate and visualize the Jira Issues macro.

Our macros "understand" the pretty recent Jira dates correctly and transform them into the standard format. Here is an example:

Tue 2-1.pngTue 2-2.pngAnd here are the examples of the Jira dashboards that you'll be able to create right in Confluence. The only difference for you as a Cloud user will be the Table Toolbox macro used to nest several macros. Other steps will be the same.

I was actually trying to use this info to build charts using your app. Nice to see you have a solution for this piece. Thanks for the screenshots!

If you get stuck somewhere, please submit a support request - attach your screenshots of the Jira Issues macro' output, describe the required chart or pivot and we'll guide you through the case.

0 votes
Fabian Lim Community Leader Dec 20, 2021

Hi @Anita Suri

This is a known issue and atlassian won't fix it.  There is a workaround posted here: https://jira.atlassian.com/browse/CONFCLOUD-41529

Regards 

Suggest an answer

Log in or Sign up to answer
DEPLOYMENT TYPE
CLOUD
PRODUCT PLAN
STANDARD
PERMISSIONS LEVEL
Site Admin
TAGS
Community showcase
Published in Confluence Cloud

🏠 Say hello to the new Confluence Home!

Hi Atlassian Community, My name is DJ Chung, and I’m a Product Manager on the Confluence Cloud team. Today, I’m excited to share a new and improved version of Home. The new Home helps you ...

42,023 views 29 132
Read article

Community Events

Connect with like-minded Atlassian users at free events near you!

Find an event

Connect with like-minded Atlassian users at free events near you!

Unfortunately there are no Community Events near you at the moment.

Host an event

You're one step closer to meeting fellow Atlassian users at your local event. Learn more about Community Events

Events near you