JQL script for exporting a timeline

[Paolo Pastorino]

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

[Tanguy Crusson · Accepted solution]

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]

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 :)