Create
cancel
Showing results for 
Search instead for 
Did you mean: 
Sign up Log in

JQL script for exporting a timeline

Paolo Pastorino
Contributor
February 27, 2023

Hi all,

we all know that the timeline view will be improved, but for now I would just need to have a way to export its content in Excel through the Jira plugin.

Nonetheless when I export the custom date field I created for "Dev start date", this is what I get in Excel (not a clean date format) 

{"start":"2023-06-01","end":"2023-06-01"}

Any guess how to fix it? 

Thanks

Paolo

1 answer

1 accepted

2 votes
Answer accepted
Tanguy Crusson
Atlassian Team
Atlassian Team members are employees working across the company in a wide variety of roles.
February 27, 2023

Hi @Paolo Pastorino , the date field is a hybrid field which can represent a period, e.g. "Jan-Mar 2023" which is modelled as {"start":"2023-01-01","end":"2023-03-31"})

In your case, if you are sure you'll always pick a single date, then you can always use a formula to extract it. I did an example in Google Sheets here: 

https://docs.google.com/spreadsheets/d/1g2i3fVjTGhKuhre3ENEVe8RcFBCU7v_MH_Hgq2pVlEI/edit?usp=sharing

Paolo Pastorino
Contributor
February 27, 2023

Thanks @Tanguy Crusson  for the explanation. I intended the date field as a date :) not as a date range. I will extract the right date in Excel :)

Suggest an answer

Log in or Sign up to answer
TAGS
AUG Leaders

Atlassian Community Events