nav[aria-label="Primary Navigation"] { padding: 0; & ul { list-style: none; width: 100%; display: flex; flex-direction: row; justify-content: start; align-items: start; gap: 30px; padding: 0; & li { margin: 0; } & ul li { list-style: none; } } }

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

Agnes_9gzmnr

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

Accepted answers

Mark Segall

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):

Olha Onofriichuk_SaaSJet

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:

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

All comments

Mark Segall

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):

Olha Onofriichuk_SaaSJet

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:

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_9gzmnr

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

Agnes_9gzmnr

Dear @Olha Onofriichuk_SaaSJet ,

Well noted and thank you for your support..

Mark Segall

Fantastic!

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.