How can I use Jira smart values to set a deadline with plusBusinessDays that is always at 9pm ET?

[Will Portman]

My research so far on the Jira forums hasn't yielded an answer... How can I use plusBusinessDays to set a deadline on a Jira field that is X business days from when the ticket is created, plus whatever amount of time it needs to be for the deadline to be consistently end-of-day?

e.g. for a ticket created Monday 9am, if the deadline formula is {{issue.Created.plusBusinessDays(3)}}, then the deadline will be Thursday 9am

For a ticket created Monday 11am, if the deadline formula is {{issue.Created.plusBusinessDays(3)}}, then the deadline will be Thursday 11am

How do I adjust the deadline formula to make this deadline Thursday 6pm for both tickets?

Thanks!!

[Bill Sheboy · Accepted solution]

Hi @Will Portman -- Welcome to the Atlassian Community!

You could set the date / time value to the start of the day plus hours (or use with... to set the specific hour), add your business days, etc.

https://support.atlassian.com/cloud-automation/docs/jira-smart-values-date-and-time/#To-date-with-time-conversion

https://support.atlassian.com/cloud-automation/docs/jira-smart-values-date-and-time/#Date-with-attribute---

https://support.atlassian.com/cloud-automation/docs/jira-smart-values-date-and-time/#Date-plus-unit---

Remember to test this to ensure it works for your desired time zone value.

Kind regards,
Bill

[Will Portman]

Thanks Bill! I think I got what I was trying to do with the below formula:

{{issue.Created.toDateTimeAtStartOfDay("America/New_York").plusBusinessDays(3).plusHours(21)}}

I hadn't realized I could feed in a timezone to get the local time at the start of the day (thought it had to be UTC which was trickier) - super helpful.

Thanks again