Automation Rule - JQL - Using Date Time Picker custom field

[Renatão]

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?

[Renatão · Accepted solution]

It works using ENDOFWEEK and STARTOFWEEK properties.

[Alexis Robert]

Hi @Renatão , 

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