JQL Date Query

David Hobaugh
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!
October 8, 2021

Hello Community,

Using Project Automation I want to run a JQL search and pass results to subsequent actions to send an email notification to user.  I created a custom date field for SHIP DATE and need the query to return tickets that are SHIP DATE minus 21 days.  What is the JQL for such a search?

1 answer

1 accepted

1 vote
Answer accepted
John Funk
Community Leader
Community Leader
Community Leaders are connectors, ambassadors, and mentors. On the online community, they serve as thought leaders, product experts, and moderators.
October 8, 2021

Hi David,

Try "Ship Date" >= startOfDay(-21d)

David Hobaugh
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!
October 8, 2021

Works, thanks!

Like John Funk likes this
John Funk
Community Leader
Community Leader
Community Leaders are connectors, ambassadors, and mentors. On the online community, they serve as thought leaders, product experts, and moderators.
October 8, 2021

Great!

Suggest an answer

Log in or Sign up to answer
TAGS
AUG Leaders

Atlassian Community Events