Showing results for 
Search instead for 
Did you mean: 
Sign up Log in
It's not the same without you

Join the community to find out what other Atlassian users are discussing, debating and creating.

Atlassian Community Hero Image Collage

How can I set an automation slack for jira when a due date is approaching?


For example, an intern will end their internship on 12/11/2021. How can I set a reminder that will be send to a channel in slack 2 weeks before the internship ended.

For Ng Sze Jin, the due date for internship is on 31st December 2021. So, I want a channel in slack to give reminder that her internship will ended in 2 weeks before the due date. I try to schedule the date and set it to every day. I am not sure if this is possible. 

image (2).png


image (1).png

I need someone help me. Thank you.

1 answer

1 accepted

2 votes
Answer accepted

Hi @Siti Nur Atikah 

You need add in your JQL sub query to filter issues based on due date. Something like this.

due >= -1w AND due <= 2w order by created DESC

I hope it helps.


can I know what do you mean by DESC?

Well it is just to get the results in descending order based on creation date. You don't have to use it.

due >= -1w AND due <= 2w 

This query should also work fine.


Like Siti Nur Atikah likes this

image (3).png

Is it the Cron expression refer for notification time?

Hi. I have tried your solution and it works for a particular person just like I wanted. Thank you. But, there is one more thing that I am not sure of. How can I change the schedule to 2 weeks before the due date. In this picture, I set the schedule every 5 minutes. But in my case, I would like to give reminder 2 weeks before due date. 

image (4).png

Suggest an answer

Log in or Sign up to answer
Community showcase
Published in Apps & Integrations

Send an Email or Publish to Confluence - What should you do with your release notes?

Background When you hear the words ‘Release notes’, almost always you think of an unsolicited email from a software vendor. But I am here to tell you that from our data, sending release notes via E...

61 views 0 1
Read article

Community Events

Connect with like-minded Atlassian users at free events near you!

Find an event

Connect with like-minded Atlassian users at free events near you!

Unfortunately there are no Community Events near you at the moment.

Host an event

You're one step closer to meeting fellow Atlassian users at your local event. Learn more about Community Events

Events near you