I have an issue that allows a user to select a person then a date and time, where the date and time is when they are going to leave the company. I need an automate way to take that issue and transition it to another status at that exact time. I do have script runner installed. I have tried a few things but everything seems to be tied to some kind of event rather than a date and time.
I see you used the scriptrunner tag, so I take it that means you have that add-on installed. If so, you can use their "Escalation Service" built in script. With it, you can schedule a script to run at regular intervals and take action (such as transitioning) on issues that match a JQL condition. Here is one that we use to close issues that have been in the "In Production" status and not updated for 45 days. You could do something similar and use JQL such as "departure > -1h" (indicating the departure date/time is within the past hour) and then run it hourly.
I just recently released a new add-on called Hyperion Scripting for JIRA. It has the feature you are looking for in form of a Scheduled Job. Though I don't have the exact script at hand right now that does exactly what you need. But as it is designed to be user friendly and comes with examples, it might be useful for you, especially if you need to deliver additional automations in the future.
Hello Atlassian Community! I'm Tania, a Senior Product Marketing Manager for Jira Service Desk Cloud! I'm excited to announce some exciting improvements coming up for those who work with queues and...
Connect with like-minded Atlassian users at free events near you!Find an event
Connect with like-minded Atlassian users at free events near you!
Unfortunately there are no Community Events near you at the moment.Host an event
You're one step closer to meeting fellow Atlassian users at your local event. Learn more about Community Events