Showing results for 
Search instead for 
Did you mean: 
Sign up Log in
Deleted user
0 / 0 points
badges earned

Your Points Tracker
  • Global
  • Feed

Badge for your thoughts?

You're enrolled in our new beta rewards program. Join our group to get the inside scoop and share your feedback.

Join group
Give the gift of kudos
You have 0 kudos available to give
Who do you want to recognize?
Why do you want to recognize them?
Great job appreciating your peers!
Check back soon to give more kudos.

Past Kudos Given
No kudos given
You haven't given any kudos yet. Share the love above and you'll see it here.

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, 



Suggest an answer

Log in or Sign up to answer
Site Admin
Community showcase
Published in Jira Service Management

ThinkTilt is joining the Atlassian Family!

This morning, Atlassian announced the acquisition of ThinkTilt , the maker of ProForma, a no-code/low code form builder with 700+ customers worldwide. ThinkTilt helps IT empower any team in their or...

148 views 8 9
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