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

Question

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."

Bill Sheboy · Answer

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

Oday Rafeh_2jhprw · Answer

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 · Answer

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