report the initial assignment date

[Naresh Lalchandani]

how to report the initial assignment date based on a status in jira?

[Christos Markoulatos]

Hi @Naresh Lalchandani 

In Jira, there’s no native field that automatically stores the initial assignment date for an issue, but you can achieve this through a combination of custom fields, automation, The most common approach is to create a custom date field called something like “Initial Assignment Date” and then use Jira Automation to populate it when the issue first transitions into the status you care about (for example, when it moves to “Assigned” or “In Progress”). The automation rule would trigger on the status change and set the current date in that custom field only if it’s empty, ensuring it captures the first assignment date and doesn’t overwrite later changes. Once this field is populated, you can include it in JQL queries, filters.

Hope this helps!

[Birkan Yildiz _OBSS_]

Hey @Naresh Lalchandani

That's a great question. Getting the exact date of when an issue first reached a specific status (which often marks the initial assignment) is difficult with native reports. People often try to use automation to stamp a custom field, but that doesn't work for your historical data.

If you are open to using a marketplace app, Timepiece - Time in Status for Jira’s First Transition To Status Date report does exactly what you are asking. It generates a list of your issues and shows the First Date each issue transitioned to the status you select.

This allows you to see the "initial assignment date" for any status in your workflow instantly, and unlike automation, it works retroactively for all your past issues immediately after installation.

You can check Timepiece out on the Atlassian Marketplace. Hope this helps you get the dates you need!

Full disclosure: I'm on the team that makes Timepiece - Time in Status for Jira.

[Naresh Lalchandani]

I tried this but stuck on this error message

customFieldId=10699 field not supported The field with the id customFieldId=10699 and type customFieldId=10699 is not supported by Automation. You can use the 'Choose fields to set' drop down above to remove this field. I tried this as well but didnt help

[Christos Markoulatos]

u have also to add the field to the screen of the project u want this to exist