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

[Siti Nur Atikah]

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. 

I need someone help me. Thank you.

[Ravi Sagar _Sparxsys_ · Accepted solution]

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.

Ravi 

[Siti Nur Atikah]

can I know what do you mean by DESC?

[Ravi Sagar _Sparxsys_]

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.

Ravi 

[Siti Nur Atikah]

Is it the Cron expression refer for notification time?

[Siti Nur Atikah]

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.