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

Will Portman
I'm New Here
I'm New Here
Those new to the Atlassian Community have posted less than three times. Give them a warm welcome!
April 9, 2024

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!!

1 answer

1 accepted

4 votes
Answer accepted
Bill Sheboy
Rising Star
Rising Star
Rising Stars are recognized for providing high-quality answers to other users. Rising Stars receive a certificate of achievement and are on the path to becoming Community Leaders.
April 9, 2024

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
I'm New Here
I'm New Here
Those new to the Atlassian Community have posted less than three times. Give them a warm welcome!
April 9, 2024

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

Like Bill Sheboy likes this

Suggest an answer

Log in or Sign up to answer
DEPLOYMENT TYPE
CLOUD
PRODUCT PLAN
PREMIUM
PERMISSIONS LEVEL
Site Admin
TAGS
AUG Leaders

Atlassian Community Events