I want the JQL which refers to the Tickets which are having the due date is today

[suneel babu]

Hello dear Community,

I want the JQL which refers to the Tickets which are having the due date is today, Every day I want to run this jql , with the Event Scheduler automation rule to check, if any Due date  is today any tickets are there, and I want to notify the support team to alert them to do something on the tickets 

the Event Scheduler automation ruler has been set up for the UTC 9:00 am Time Zone

Pls guide me.
Thanks in advance.

Regards,
Suneel 

[Marc - Devoteam · Accepted solution]

Hi @suneel babu 

Use the JQL clause: 

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

[Tobias H]

Hi @suneel babu!

You should be able to accomplish this by adding duedate = startofDay() to the query of your choice. But it might be good to limit it to the project(s) you want it to trigger from.

Best, Tobias