Create
cancel
Showing results for 
Search instead for 
Did you mean: 
Sign up Log in
It's not the same without you

Join the community to find out what other Atlassian users are discussing, debating and creating.

Atlassian Community Hero Image Collage

Automation Rule - JQL - Using Date Time Picker custom field

I'm trying to configure an automation rule for change management requests in my Jira Service Management project.

Basically, I have a custom field (Date Time Picker) called Planned Start Date. I want to make a decision based on when the request is planned to be implemented.

If change is planned to occur on Saturday or Sunday, I want to make a transition to state 1. Else:

    If change is planned to occur from 8AM to 10PM, I want to make a transition to state 2. Otherwise, I want to make a transition to state 1.

I tried to use "Planned Start Date".dayOfWeekName, but it does not work. Or "Planned Start Date".endOfDay(-2h), for instance, and it does not work also.

Any thoughts?

2 answers

1 accepted

0 votes
Answer accepted

It works using ENDOFWEEK and STARTOFWEEK properties.

0 votes
Alexis Robert Community Leader Mar 05, 2021

Hi @renato_matos , 

 

the correct way to get the day of the week with Smart value is : 

 

{{"Due Date".format("EEEE")}}

 

You can then use this to compare with a date in your IF statement.

 

Let me know if this helps, 

 

--Alexis

Suggest an answer

Log in or Sign up to answer
DEPLOYMENT TYPE
CLOUD
PRODUCT PLAN
STANDARD
PERMISSIONS LEVEL
Site Admin
TAGS
Community showcase
Published in Jira Service Management

JSM Jira Automation: How to Send SLA Breached Notifications

Hi Everyone, In   this tutorial,  we will show you how you can monitor an SLA, and send notifications before or after the SLA has been breached.   SLA Threshold Trigger The SLA t...

626 views 5 12
Read article

Community Events

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

Events near you