Can you help me, how to set automation reminder(send email) when now date is 90 days before due date

[Agnes]

I need a reminder automatically always starts when the now Date is 90 days before due date of my issue/task, then continually after that the reminder sent again every 1 weeks.

How can I set this condition?

Thank you

[Mark Segall · Accepted solution]

Hi @Agnes and welcome to the community!

You had me intrigued with the need for weekly updates as I was thinking there has to be a straightforward way to handle this. Here's what I did in my test environment:

• TRIGGER: Scheduled (Daily)

  • statusCategory != Done AND dueDate >= startOfDay() AND dueDate < startofDay(91d)

• IF CONDITION (Advanced Compare): Here we check to see if this is the 90 day warning

  • {{now.plusDays(90).jiraDate}}
    Equals
    {{issue.dueDate}}

  • ACTION: Send Email
• ELSE CONDITION (Advanced Compare):  Here's where we're checking to see if the issue is exactly n weeks from the Due Date.  This formula is evaluating whether it's a whole number.  If it is, send another alert.

  • {{#=}}FLOOR({{now.diff(issue.dueDate).days}}/7){{/}}
    Equals
    {{#=}}CEILING({{now.diff(issue.dueDate).days}}/7){{/}}

  • ACTION: Send Email

Here's a screenshot of what I did. I added variables in here for testing, but they could also be useful for giving dynamic email messages (e.g. You have n weeks remaining until your due date):

[Agnes]

Dear @Mark Segall ,

Thank you for your support. I have already tried it and success.

I can use it for my tasks..

Really appreciate for your response and help :)

[Mark Segall]

Fantastic!  

[Olha Onofriichuk_SaaSJet · Accepted solution]

Hi, @Agnes 

Actually, this may be easily done whin any amount of reminders you need. Recently, I've written a few articles about how you can set this process up: 

• Notify before the deadlines of Jira issues
• How to send a few notifications before the due date

If you need, I (or my team) can show you how to set automation reminder whenever you need via SLA Time and Report for Jira add-on. This plugin can definitely help you with your question.

Let me know, if you need more information or help with such settings.

Have a great day.

Sincerely,
Olha

[Agnes]

Dear @Olha Onofriichuk_SaaSJet ,

Well noted and thank you for your support..

[Olha Onofriichuk_SaaSJet]

@Agnes I'm glad it helped you! Feel free to message me if you need any help with setting up sending the reminders.