Automate transition when an issue date has been passed by 1 day.

[Ali]

Hey there! Very new to JIRA, and I mostly use it for trying to automate some Ops functions in our company. Not a regular user of JIRA by any means.

I'm trying to figure out a way to create an automation of a transition of a card based on when the date of a particular issue on the card has passed.

For example -- The card has an issue named "Return Date" set to 6/7. On 6/8, I'd like JIRA to automatically move the card to a new status.
I think the second part of the JQL search and execute function is:

= startOfDay ("-1d")

But I'm not sure how to indicate the custom issue. Any help would be greatly appreciated!

[Trudy Claspill]

Hello @Ali 

Welcome to the Atlassian community!

Is "Return Date" the name of a custom field? If so, what type of field? Is it a Date Picker field or a Date/Time field?

Does it matter what the current status of the issue is, or do you want to transition it regardless of its current status?

What do you mean by "indicate the custom issue"? What other attributes of the issue need to be considered when selecting the issues you want to transition?

[Ali]

Hey Trudy!

I think I figured it out, but for others who might have this question--

The field is a date picker field. I wanted the card to transition regardless of the status.

I was able to mess around with the search function to find this formula that I think works.

project = PROJECTNAME AND "Return Date[Date]" = startOfDay("-1")

Pretty simple XD

[Bill Sheboy]

Hi @Ali -- Welcome to the Atlassian Community!

Adding to Trudy's answer and the JQL you are using...

Please consider there can be delays in rule execution due to errors and outages.  What would you want your rule to do when more than one day has passed, and so the condition will never be met?  Considering how to handle such cases will reduce the need for manual clean-up if the rules skip a day (or more).

Kind regards,
Bill

[Bisrat Shebeshe]

Hello @Ali 

You can indicate the specific issue using the text included in the issue summary, you can specify further by using the project name and issue type.

For example if you want to specify the issue issue named "Return Date", you can use the JQL query: 

summary ~ "Return Date" AND created >= -1d

[Ali]

Oh, great point! Yeah, I would want anything with 1 day past or more to transition regardless of status. Thanks!