Send an automated email out after 7 days of a date field

Mark
I'm New Here
I'm New Here
Those new to the Atlassian Community have posted less than three times. Give them a warm welcome!
April 1, 2024

I have a field called 'start date'. I'm looking to set up an automation that will send an email exactly 7 days after the specified start date. I already have a scheduler running daily, I need a condition to compare the start date with today's date and check if it's 7 days ahead of today."

1 answer

1 vote
Bill Sheboy
Rising Star
Rising Star
Rising Stars are recognized for providing high-quality answers to other users. Rising Stars receive a certificate of achievement and are on the path to becoming Community Leaders.
April 1, 2024

Hi @Mark -- Welcome to the Atlassian Community!

You can check that by adding to the JQL the scheduled trigger uses, such as with the now() or startOfDay() functions, and adding an increment, such as:

project = yourProjectName AND "Start date" = startOfDay(7d) ORDER BY "Start date" ASC

https://support.atlassian.com/jira-software-cloud/docs/jql-functions/#startOfDay--

Kind regards,
Bill

Oday Rafeh
Rising Star
Rising Star
Rising Stars are recognized for providing high-quality answers to other users. Rising Stars receive a certificate of achievement and are on the path to becoming Community Leaders.
April 1, 2024

Hey Bill,

It seems Mark has a slightly different need. He wants an email notification to be sent 7 days after the start date, not on the exact date itself.

For this scenario, the separate condition with the JQL:

 

startdate > currentdate - 7d


seems like the best approach. This checks for issues where the start date has already passed but is still within 7 days, which aligns perfectly with Mark's email notification requirement.

Cheers

Oday

Bill Sheboy
Rising Star
Rising Star
Rising Stars are recognized for providing high-quality answers to other users. Rising Stars receive a certificate of achievement and are on the path to becoming Community Leaders.
April 2, 2024

Hi, Oday. 

The current text of the question states (emphasis added by me):

"...will send an email exactly 7 days after the specified start date"

Thanks,
Bill

Like Oday Rafeh likes this

Suggest an answer

Log in or Sign up to answer
DEPLOYMENT TYPE
CLOUD
PRODUCT PLAN
PREMIUM
PERMISSIONS LEVEL
Site Admin
TAGS
AUG Leaders

Atlassian Community Events