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."
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
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
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
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
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Online forums and learning are now in one easy-to-use experience.
By continuing, you accept the updated Community Terms of Use and acknowledge the Privacy Policy. Your public name, photo, and achievements may be publicly visible and available in search engines.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.