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)