Create
cancel
Showing results for 
Search instead for 
Did you mean: 
Sign up Log in

Reminder baased on custom date field - 30 days prior

Drishti Maharaj
Contributor
August 21, 2024

Hi,

So I have a custom field called "Access Termination Date" and I want a possible email reminder to go off 30 days prior to the date in the field.

However, I am unable to get the right query.

I have Issue-1 with the "Access Termination Date" set to 10th August 2024 and Issue-2 with the "Access Termination Date" set to 20th September 2024.

I have tried "Access Termination Date[Date]" >= startOfDay(-30)

Which brings up all the issues including Issue-1 when technically the "Access Termination Date" has passed.

I am not too sure what I may need to change.

Thanks.

 

2 answers

1 accepted

3 votes
Answer accepted
Rilwan Ahmed
Community Leader
Community Leader
Community Leaders are connectors, ambassadors, and mentors. On the online community, they serve as thought leaders, product experts, and moderators.
August 21, 2024

Hi @Drishti Maharaj ,

You need to remove minus in the query.
i.e. "Access Termination Date[Date]" >= startOfDay(30)

If you want exactly 30 days, then use "Access Termination Date[Date]" = startOfDay(30)

To get the email reminders, make use of filter and subscriptions. 
https://www.atlassian.com/blog/jira/jql-the-most-flexible-way-to-search-jira-3-of-4

Drishti Maharaj
Contributor
August 21, 2024

Thank you @Rilwan Ahmed - this worked.

Like Rilwan Ahmed likes this
0 votes
Manoj Gangwar
Community Leader
Community Leader
Community Leaders are connectors, ambassadors, and mentors. On the online community, they serve as thought leaders, product experts, and moderators.
August 21, 2024

You may try the below JQL.

"Access Termination Date[Date]" < startOfDay(-30) AND "Access Termination Date[Date]" >= startOfDay(-30)

Suggest an answer

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

Atlassian Community Events