Reminder baased on custom date field - 30 days prior

[Drishti Maharaj]

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.

[Rilwan Ahmed · Accepted solution]

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]

Thank you @Rilwan Ahmed - this worked.

[Manoj Gangwar]

You may try the below JQL.

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