Automation Rule executes but returns no results

[Atif Saad]

Hi, I created an automation rule. Basically, I need to send an email to assignee if task is due today. As well as send a Slack channel message to a specific channel. I am trying this JQL query. 

project = BM AND duedate = startOfDay()

I also tried what this article said, exact same query under the project. How can I set reminder before Due date for my task... (atlassian.com)

Neither are working. Automation audit log says No actions performed. 

There is only 1 task in the sprint that has status of in progress and due date of today, created by me and assigned to me. I am testing the automation before setting it up for others in my team.

What am I doing wrong? Any help please.

[Alex Koxaras _Relational_ · Accepted solution]

Hi @Atif Saad and welcome to the community,

Can you please change your JQL to:

duedate >= startOfDay() and duedate <= endOfDay()

And try again? Also click on validate query to see if the above query returns any results.

Let me know.

[Atif Saad]

Thanks @John Funk @Alex Koxaras _Relational_ it worked. The problem was not the query but the due date field. There were multiple due date fields that were created. After using the correct field, both queries worked. Thanks again.

[John Funk]

Glad to hear you solved it.

[John Funk]

Hi Atif - Welcome to the Atlassian Community!

Try this for your query:

duedate >= startOfDay(-1)