Custom Due Date Field Automation Email

Question

I made a custom field called Follow Up Due Date. It was made with the Date and Time picker off of custom fields. I need help with making a JQL. I want to make and automated email that goes out when the date and time is due to the Assignee of the ticket. Is there a way of doing thins. I was playing around with the Scheduled Automation. I got this much of the JQL I just don't know how to properly connected to the custom filed.

JQL:

project in (Test) and  (not sure what to put here) < 0 and status in ("Sent") or ("Waiting on Customer")

Any help would be greatly appreciated!

Hector.Hood · Answer

Going to try this out. Thank you so much for the quick response. I will let you know how it works out.

Dave LIAO · Answer

@Hector.Hood - try this JQL?

project = TEST and "Follow Up Due Date" <= "0" AND status in ("Sent", "Waiting on Customer")

Hope this helps!