Projected end date in closed sprints

[Ángela Alcoba]

When I close a sprint in a sprint report, I see the date when the srint was closed, but I need to see the date in which that close "Projected end date" was programmed. How do I see this information in closed sprints? regards

[Andy Heinzer]

This information is actually not something you can find in Jira's web interface once the sprint has been closed.   True, you can see this date when the sprint is still open in the sprint report, however once a sprint is closed, that estimated date is replaced with the actual date/time the sprint was closed.

However the SQL database that Jira uses does store this estimated date in a table that can still be referred to.   In postgresql you can use a query such as

SELECT "CLOSED", "COMPLETE_DATE", "END_DATE", "GOAL", "ID", "NAME", 
       "RAPID_VIEW_ID", "SEQUENCE", "STARTED", "START_DATE"
  FROM "AO_60DB71_SPRINT";

to see a complete list of all sprints, the boards on which they were created, the time they were created, as well as the the estimated end date.  In this case, the column called "END_DATE" is the value that represents the estimated end date/time.  

Jira is storing this date/time value in a unix epoch time format.   As such you would likely need to convert this, either via some slick SQL typecasting, or you could just take the value there and use another tool, like the site https://www.epochconverter.com/ in order to convert this value into a date and time that a human can read.