Sprint start and end date are IDs

Question

Hi guys, I’m trying to bring in the sprint start and end date from AO_60DB71_SPRINT in a SQL statement.

The date looks like an ID.

Any idea how, where I can get the actual date? How to use the ID

Daniel Eads · Accepted Answer

Hi Ian,

The dates are actually in Unix Epoch format. There are a myriad of tools available for converting them into a human-readable format, but here are a couple that might be useful.

* Converting in-browser online (epochconverter.com)
* Doing it in Python
* Doing it in Javascript
* Casting the time to human readable formats in various SQLs

Cheers,
Daniel